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.
| Attachment | Size |
|---|---|
| Patient organization.xlsx | 11.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.