I want to apply conditional formatting (fill cell with red) to all rows in columns F, I, L. E,F,I,H,L,K columns contain number values.
我想将条件格式（用红色填充单元格）应用于列F，I，L中的所有行.E，F，I，H，L，K列包含数字值。
Condition is if F3 < E3 fill F3 with red, I3 < H3 fill I3 with red, L3 < K3 fill L3 with red and so on. It will go on like: F4 < E4 true, I4 < H4 true, L4 < K4 true.
条件是如果F3
sample table:
样本表：
http://pbrd.co/1bs0B2Z
How will I do this? I think I have to do self reference in conditionally formatted cells.
我该怎么做？我想我必须在条件格式化的单元格中进行自我引用。
1 个解决方案
#1
5
in conditional formatting for F3, put =(F3<E3) - note you will have to type this, as clicking on the cells will give fixed addresses (with the $ sign), which we don't want.
在F3的条件格式中，put =（F3
Once you have this, copy the formatting to all required cells. Excel will adjust the range for each cell. This will not show up in the formula for the conditional formatting, but the format changes will show that it is being calculated dynamically.
完成后，将格式复制到所有必需的单元格。 Excel将调整每个单元格的范围。这不会显示在条件格式的公式中，但格式更改将显示它是动态计算的。
#1
5
in conditional formatting for F3, put =(F3<E3) - note you will have to type this, as clicking on the cells will give fixed addresses (with the $ sign), which we don't want.
在F3的条件格式中，put =（F3
Once you have this, copy the formatting to all required cells. Excel will adjust the range for each cell. This will not show up in the formula for the conditional formatting, but the format changes will show that it is being calculated dynamically.
完成后，将格式复制到所有必需的单元格。 Excel将调整每个单元格的范围。这不会显示在条件格式的公式中，但格式更改将显示它是动态计算的。