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?