How to ignore blank cells in conditional formatting?

**Gooford** · 02-15-2010, 06:35 AM

I have tried to set up a list of cells to highlight in red any numerical values which are greater than 0 using conditional formatting.

This works fine, except that all blank cells are also highlighted in red.

Formula is currently:

cell value is greater than 0

What do I need to do to ignore the empty cells?

Thanks in advance

**Richard Buttrey** · 02-15-2010, 06:39 AM

Hi,

Rather than using the Cell Value cond format, Use the Formula Is option and specify

Please Login or Register  to view this content.

HTH

**Gooford** · 02-15-2010, 06:45 AM

ace cheers!

**AndyHawke** · 08-22-2012, 07:39 AM

Hi,

I have a sheet where I have a list of items which need to be completed by different dates. In column E I have the date which the item needs to be completed by and in column f I have the date it was actually completed by.

I want E to display green if F includes a date (ie if the job is complete show green).
I want E to display orange if F is less than two weeks from today
I want E to display red if F is before today

This is all fine... I've set up the following rules in E in the "use formula..." section:

Show green: =F7>0
Show orange: =(E7-TODAY())<14
Show red: =(E7-TODAY())<0

What I need is for the empty cells in E to have no formatting but instead they are all red. Since there are some rows which have nothing in (to seperate different sections) this looks messy. Since I won't be filling this in I don't want others to have to change the formatting.

Any help would be gratefully received as my brain is hurting now. =)

Thanks,

AH

**jeffreybrown** · 08-22-2012, 07:55 AM

Hi Andy & Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.

**AndyHawke** · 08-22-2012, 08:06 AM

Hi Jeff,

Many thanks for the welcome.

Sorry about breaking the rules... I should have read these more closely. New thread submitted.

Thanks again,

Andy