How to do conditional formatting using self reference in excel

3
votes

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.

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.

sample table:

http://pbrd.co/1bs0B2Z

How will I do this? I think I have to do self reference in conditionally formatted cells.

1
excelconditional-formattingself-reference
please put rows sample- thanks - Pericles
Self referencing is not a problem in Conditional Formatting - Cool Blue
@Cool Blue Could you show me how to do it? What should the formula look like? - alwbtc

1 Answers

6
votes

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.

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.