Conditional Formatting to Check for Blanks

[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.

 

[Bernard Liengme]

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

 

[Mike H]

daren,

Select the cell then

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

Mike

 

[Daren]

No, but thank you. I am using =g2="" instead. That works also.

 

[Daren]

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

 

[Daren]

Thanks, it worked.

daren,

Select the cell then

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

Mike