So i have varrious assets which i track that expire, i've figured out a rule that will highlight the dates of assets within 6 and 3 months of expiring, however my rule for less then three months is a less then statement which also formats any blank cells.
i'm trying to figure out a rule i can use to make conditional formating ignore blank cells.
Bookmarks