View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Barbara Wiseman[_3_] Barbara Wiseman[_3_] is offline
external usenet poster
 
Posts: 2
Default Conditional formatting - not equal to cell above

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