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

 

[thisisraymond]

David Biddulph wrote on 10/30/2009 07:34 ET

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

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


"muddan madhu" wrote in messag
news
Select the rang

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



On Oct 30, 4:45 pm, Barbara Wiseman wrote

I am having a problem with this formula if the cells are dates. An
suggestions?