Conditional formatting a whole column but with the conditions < &
 

I am trying to get cells D2 thro' D71 to turn red if D65 cell formula is
63.0 and to turn yellow if D65 formula is <57.0
Formula in D65 is =D9/D10*D11*50
I have the following conditional formulas set up
Formula is =D$65"63.0"
Formula is =D$65<"57.0"
But it will only turn yellow & seems to do this as soon as I enter data is
cell D9
Please help

Conditional formatting a whole column but with the conditions < &
 

By putting your comparison values in quotes you are comparing with text
strings. If you want to compare with numbers, throw away the quote marks.
--
David Biddulph

"Carolyn" wrote in message
...
I am trying to get cells D2 thro' D71 to turn red if D65 cell formula is
63.0 and to turn yellow if D65 formula is <57.0
Formula in D65 is =D9/D10*D11*50
I have the following conditional formulas set up
Formula is =D$65"63.0"
Formula is =D$65<"57.0"
But it will only turn yellow & seems to do this as soon as I enter data is
cell D9
Please help

Conditional formatting a whole column but with the conditions < &
 

Formula is =D$65"63.0"
Formula is =D$65<"57.0"

Remove the quotes:

=D$6563
=D$65<57

The second formula can be made more robust so that an empty cell won't be
formatted (if D65 might ever be empty):

=AND(COUNT(D$65),D$65<57)

An empty cell will evaluate to 0 and 0 < 57.


--
Biff
Microsoft Excel MVP


"Carolyn" wrote in message
...
I am trying to get cells D2 thro' D71 to turn red if D65 cell formula is
63.0 and to turn yellow if D65 formula is <57.0
Formula in D65 is =D9/D10*D11*50
I have the following conditional formulas set up
Formula is =D$65"63.0"
Formula is =D$65<"57.0"
But it will only turn yellow & seems to do this as soon as I enter data is
cell D9
Please help