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?

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?

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?

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?

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?

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?

Hi,

Just change the formula to

=C2<D2

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"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?