Need som help!

I have started a basic spreadsheet. The only problem I am having is trying to figure out how to set up a conditional formula for expiration dates. Basically, 14 days before expiring, I want the cells in a column to change to a different color. However, when I set up the formula all of the dates change color regardless of the date and the blank cells change color as well. What am I doing wrong? I am ok with the other columns. It is column N that I am having trouble with. Thank you in advance.

AttachmentSize
Patient organization.xlsx11.7 KB

Solution

Hello Ladycards - Here you go for the solution.
1.You need to color the cells which has expiry date before 14 days. Need to write formula to use Today formula instead of Now.

=N2-TODAY()=14

which identifies all the cells which has exactly 14 days expiry.

If you all the cells less than <=14 days expiry to hightlight.
=N2-TODAY()<=14

Hope this solution will solve your problem.

Regards
Vinod.