Background: I have a spreadsheet and I'm using a simple formula (=IF(K5>J5,"Expired","Valid").
K5 is an expiration date, J5 uses the formula =Today().
If todays date is greater than the expiration date then the status should be Expired otherwise status will be Valid.
I have two questions:
1. not all entries will have an expiration date, so how can I add into the formula if the K5 is null display N/A?
2. Is it possible to have the font color change based on the status? (example: I'd like to have all Valid status appear in green, and all Expired appear in red.