LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 58
Default Conditional formatting - check for blank cell

In Excel 2003, I'd like to apply colored shading to a cell if it's blank.

I select:
Cell Value Is
equal to
""

When I check it, the value box contains:
="""""" (6 quotation marks)

I can edit the value so it reads:
="" (2 quotation marks)

and that works.

But there's got to be an easier way to enter a conditional format to check
for a blank cell. Any suggestions?

Thanks.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting if cell is Blank Judi Excel Worksheet Functions 3 April 25th 23 07:42 PM
formula setting cell type to blank and conditional formatting CEG_Staffer[_2_] Excel Worksheet Functions 6 July 17th 09 06:46 PM
Conditional formatting to test blank text cell Andyjim Excel Worksheet Functions 4 January 10th 08 08:45 PM
put zero in blank cell using conditional formatting Terry Excel Worksheet Functions 5 March 22nd 07 08:38 PM
conditional formatting blank cell TREK5200 Excel Discussion (Misc queries) 1 December 6th 04 02:23 AM


All times are GMT +1. The time now is 02:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"