Select the range

Goto format menu | conditional formatting | =T6<T5



On Oct 30, 4:45*pm, Barbara Wiseman wrote:
I am trying to colour a cell if it is not equal to the cell above.
I have tried cell value is, not equal to, =t6. *But this just copies
down as an absolute value, I need it to be dynamic so each cell is
compared with the one above.
I am sorry for such a basic question, I am not good at all with
conditional formatting!
This is on excel 2003.

Barbara