Conditional Formatting for Expired and Soon-To-Be-Expired Dates

[jgarner]

I'm currently using conditional formatting with these rules:

=K2<=TODAY()
This is for expired dates. Cell is red, font is white.

=AND($K2>TODAY(), $K2-TODAY()<=30)
This is for upcoming expiration dates within 30 days. Cell is orange, font is black.

=AND($K2>TODAY(), $K2-TODAY()<=90)
This is for upcoming expiration dates within 90 days. Cell is yellow, font is black.

The formatting works well. However, my cell range is from K2-K100, and any blank cell is red as if it's an expired date. Is there a way to keep blank cells without color?

Win7 / Office 2013

 

[ajamess]

Make a rule at the top priority

=k2 = ""

Cell is White, Font is black.

 

[jgarner]

That's exactly what I needed. Thank you.

 

[ajamess]

Sometimes the easy answer gets past us . Good luck!