Disregard conditional formatting if cell is blank

's Computer Specifications

I am a novice. I want my cell to highlight if the value is zero. But if it
is blank, or greater than zero, I do not want it to highlight.

I imagine there is an easy way to do this but I haven't figured it out.

Can anyone help?

Thank you so much.

's Computer Specifications

Format>CF>Formula is: =AND($A1=0,NOT(ISBLANK($A1)))

How about if the value is less than 0?

Gord Dibben MS Excel MVP

On Tue, 11 Dec 2007 16:52:01 -0800, veronica
<(E-Mail Removed)> wrote:

>I am a novice. I want my cell to highlight if the value is zero. But if it
>is blank, or greater than zero, I do not want it to highlight.
>
>I imagine there is an easy way to do this but I haven't figured it out.
>
>Can anyone help?
>
>Thank you so much.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional Formatting Help when a Cell is Blank	Nickle	Microsoft Excel Worksheet Functions	2	22nd Mar 2010 05:20 PM
Conditional Formatting if cell is Blank	Judi	Microsoft Excel Worksheet Functions	2	7th Aug 2009 10:18 PM
Conditional formatting formula for when 1 cell if blank _and_ another cell is not?	StargateFanNotAtHome	Microsoft Excel Discussion	2	11th Aug 2008 06:08 PM
put zero in blank cell using conditional formatting	Terry	Microsoft Excel Worksheet Functions	5	22nd Mar 2007 08:38 PM
conditional formatting blank cell	=?Utf-8?B?VFJFSzUyMDA=?=	Microsoft Excel Misc	1	6th Dec 2004 02:23 AM