I have a table (called "MyTable") and I want to use conditional formatting to format the entire row of a table using a condition that is based on a column in that table.
Here's a little demo:
I want to format the whole row if Location = "London". I'm hoping I can use the "Use a formula to determine which cells to format" option of Conditional Formatting. Hence I selected all the cells in the table and tried to enter this formula: =[@Location]="London"
but it didn't have the desired affect:
是否可以根据某些条件格式化整行,如果可以,其公式是什么?
您不能直接在 CF 中使用结构化引用,但您可以进行简单的修改:
=INDIRECT("Table1[@Location]")="london"
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)