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: 1
Default Conditional Formatting Cells With Values 0 and Null

I want the background of a cell one color if it holds a value of 0, another
color if it is null or empty, and another color if the value is 0<11. It
seems that Excel treats 0 and an empty cell the same. Whatja think?
 
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 for Values in 3 cells tvh Excel Worksheet Functions 4 July 10th 08 06:22 AM
Conditional Formatting of cells containing interger values tralbert Excel Discussion (Misc queries) 6 April 24th 08 08:22 PM
Conditional Formatting of Cells with Multiple Cell Values BDankas Excel Discussion (Misc queries) 4 September 6th 07 07:06 PM
Conditional Formatting on Null Value Ember Excel Worksheet Functions 4 July 24th 07 09:26 PM
cntrl + down arrow and null values in cells Craig Excel Discussion (Misc queries) 2 October 26th 05 10:23 PM


All times are GMT +1. The time now is 07:21 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"