Thread: Conditional Formatting to Check for Blanks
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme Bernard Liengme is offline
external usenet poster
  
Posts: 4,393
Default 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.


Reply With QuoteReply With Quote