How to get Conditional Formatting to ignore blank cells?

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

Hi Andy,

try using ISblank function.. but be sure that it does'nt work if there is any formula even if the formula is fetching blank ("")..
=isblank(E7)

regards,
DILIPandey

<click on below 'star' if this helps>

Cheers

Please mark this thread as [SOLVED].. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>