Conditional Formatting

[deck-b]

Hi All

Need some help with a conditional formatting problem

I want to format a row of cells based on the value of the cell beneath it, eg. highlight in green if value in the cell is greater than the cell beneath it, and highlight in red if the value is less than the cell beneath it.
So, cell value < D$28, Format is Red, Applies to $D$27:$Z$27. <d$28 $D$27:$D$60
This work fine in column D, but column E,F,G etc are reading the value from cell D28 and not moving across to E28, F28 etc. Is there an easy way of changing this without having to manually change each cell?

Thanks in advance
Declan</d$28>

 

[Joe4]

If you highlight the whole range you want to apply it to, D27:Z27, and then write the formula (using the Formula option) as it pertains to the first cell in your selection, Excel is smart enough to adjust it for all the other cells.

So, I would use the formulas:

=D$27 > D$28

and

=D$27 < D$28

Note: If you view the formulas in the other cells after you do this, they will still show the formula for the first cell, but rest assured it is being calculated properly for the other ones.

 

[deck-b]

Works perfectly Joe4, thanks a million!

 

[Joe4]

You are welcome!
Glad I could help!