Conditional Formatting to Check for Blanks

  • Thread starter Thread starter Daren
  • Start date Start date
D

Daren

I have the formulat =IF(G2="","True", "False")

I want to use conditional formatting to turn the cell red when the value is
True. How do I do that?

Thanks.
 
Have you tried =ISBLANK(G2) as the formula in the conditional formatting
dialog?
best wishes
 
daren,

Select the cell then

Format|Conditional format
Select 'Formula is'
enter the formula
=G2=""
Click format
patterns tab
Pick your colour
OK

Mike
 
Thanks, I switched to that formula and used the conditional format also to
pick up the true value. Thanks.
 
Thanks, it worked.

Mike H said:
daren,

Select the cell then

Format|Conditional format
Select 'Formula is'
enter the formula
=G2=""
Click format
patterns tab
Pick your colour
OK

Mike
Click to expand...
 
Back
Top