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