View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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.