Conditional format by date - Formatting when blank

[jimmisavage]

Hi,
I have a straightforward conditional format =$H2<TODAY()+1 to fill a cell based on the date. It works great... only it also fills the cell when it's blank. Is there a way to stop it from doing this?

Many thanks
Stuart

 

[MadHatsJess]

Hi,
I have a straightforward conditional format =$H2<today()+1 a="" is="" this?

Many thanks
Stuart

What's your question?

</today()+1>

 

[jimmisavage]

Oh, it didn't seem to post the rest of it!!

Aghghg - give me 2 minutes

 

[jimmisavage]

Okay, so it wasn't letting me post the formula

=$H2<today()+1[ code]

It works as expected but my formatting is also applied when the cell is blank. This is something I don't want to happen. Is there a way to prevent it from formatting on a blank cell? I know i could add another format on top of it but i have a few formats and that would mess up a number of others.

WOW, it really doesn't want me to add the formula!! it's the H2 followed by < today() plus 1</today()+1[>