Conditional Formatting
Thank you very much. A great help.
"Sheeloo" wrote:
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 =E2D2 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...
"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?
|