Conditional Formatting to Check for Blanks
 

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.

Conditional Formatting to Check for Blanks
 

Have you tried =ISBLANK(G2) as the formula in the conditional formatting
dialog?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Daren" wrote in message
...
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.

Conditional Formatting to Check for Blanks
 

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" wrote:

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.

Conditional Formatting to Check for Blanks
 

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

"Bernard Liengme" wrote:

Have you tried =ISBLANK(G2) as the formula in the conditional formatting
dialog?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Daren" wrote in message
...
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.

Conditional Formatting to Check for Blanks
 

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

"Mike H" wrote:

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" wrote:

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.

Conditional Formatting to Check for Blanks
 

Thanks, it worked.

"Mike H" wrote:

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" wrote:

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.