Conditional formatting - not equal to cell above

[Barbara Wiseman]

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

 

[muddan madhu]

Select the range

Goto format menu | conditional formatting | =T6<>T5

 

[Barbara Wiseman]

Maddan,
Thank you so much, this does exactly what I need.
Barbara

 

[David Biddulph]

In that case you would need "Formula is", not "Cell value is"

The "Cell value is" not equal to =T6 would sound OK to me, but if you say it
is copying down as an absolute value, check that Excel hasn't either put
quote marks around your expression to make it a text string, or added dollar
signs to make the address absolute.
--
David Biddulph


Select the range

Goto format menu | conditional formatting | =T6<>T5