Conditional Formatting

[Alanclen]

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?

 

[Bob I]

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

 

[Sheeloo]

Select the range you want to highlight starting at D2, say D2:F41
Then click on Conditional Formatting
Choose New Rule
Click on 'Use a Fourmua...'

Enter the formula as
=D2>$C2
and choose the formatting you want...
[note the $ before C2, if you do not give that then the conditon will change
to =E2>D2 in E2 which you don't want]

You can also do the above after just selecting D2 and provide the range in
'Applies To' field in Conditional Formatting...

 

[Alanclen]

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

 

[Alanclen]

Thank you very much. A great help.

Select the range you want to highlight starting at D2, say D2:F41
Then click on Conditional Formatting
Choose New Rule
Click on 'Use a Fourmua...'

Enter the formula as
=D2>$C2
and choose the formatting you want...
[note the $ before C2, if you do not give that then the conditon will change
to =E2>D2 in E2 which you don't want]

You can also do the above after just selecting D2 and provide the range in
'Applies To' field in Conditional Formatting...

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

 

[Sheeloo]

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.

 

[Shane Devenshire]

Hi,

Just change the formula to

=C2<D2