Conditional Formatting
 

I know how to do the Conditional Formatting if it is in the same cell but I
do not know how to do it for the following:

I would like to set a it so that Cell background in A:1 and A:2 would turn
RED if the if the value in Cell D:2 is less than 60.00%.

Thanks

Keith

Conditional Formatting
 

Keith,

Select both cells before you open the Conditional Formatting dialog.

In the dropdown box choose "Formula Is". Then enter this in the formula
box:

=$D$2<=0.6

hth,

Doug


"KAnoe" wrote in message
...
I know how to do the Conditional Formatting if it is in the same cell but I
do not know how to do it for the following:

I would like to set a it so that Cell background in A:1 and A:2 would turn
RED if the if the value in Cell D:2 is less than 60.00%.

Thanks

Keith

Conditional Formatting
 

THANKS Doug

"Doug Glancy" wrote:

Keith,

Select both cells before you open the Conditional Formatting dialog.

In the dropdown box choose "Formula Is". Then enter this in the formula
box:

=$D$2<=0.6

hth,

Doug


"KAnoe" wrote in message
...
I know how to do the Conditional Formatting if it is in the same cell but I
do not know how to do it for the following:

I would like to set a it so that Cell background in A:1 and A:2 would turn
RED if the if the value in Cell D:2 is less than 60.00%.

Thanks

Keith