Did you try it out?

The formula will take care of it...
=D2$C2 will be changed to =E2$C2 for the cell E2... and so on just as your
formula changes if you copy it to other cells.

"Alanclen" wrote:

The other valus can change. eg C2=3, D2=5, E2=7, F2=4. Therefore I would
need D2 & E2 to show in red as in each case they are greater than the
previous cell

"Bob I" wrote:

Yes. Of course e2 etc.etc are never going to change, only d2

Alanclen wrote:

I have a column of values (C2:C41) which will be updated in the following
columns on a weekly basis. I need to format the following columns so that if
value in d2 is greater than c2 show value in red. then if e2 isgreater than
d2 etc, etc. Is this possible in excel 2007?