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
|