Conditional formatting formula non-blanks

[mcivli65]

I need to highlight dates before they expire, but I only want to highlight cells with data in them. I tried the following formula, it doesn't work. The first part will highlight, but also highlights cells with nothing in them. The second part doesn't eliminate the blanks. Can anyone help me figure out what I'm doing wrong?

=($I1<=TODAY()+90),-->0

[melegaunt]

You could put an IF statement in there.. like =IF(OR($I1=0,$I1=""),0,($I1<=TODAY()+90),-->0 )
So your saying that if the cell is Zero or Blank, do nothing, if not run the code.

[mcivli65]

Thank you so much!