I'm trying to conditionally format a column to highlight in red when the current date goes past the expiration date that is written in the cell. I tried a few different options and I can't get it work. This current rule isn't working as the item in red is in the future, yet the expired date at the bottom isn't highlighted in red. Help!
Hi zimm…
CH rules can be confusing!
"Date is before" means 'when the date in the cell is before the date 'this many days from TODAY' or 'this many days ago (from today)
Here's a sample that changes the colours as the due date approaches then passes "today".
Same set of rules is applied to the due dates in column D.
TODAY when the screen shot was taken is shown in cell B2.
Regards,
Barry
If I understand you correctly then one way would be to set a rule like this:
SG
Thanks for the explanation. I didn't know the program was smart enough to know today's date. I was even making a cell with the current date and trying to reference that with the formatting. What a mess. Wish I had taken a spreadsheet class when I was in college.
That did it! Thank you.
conditional formatting for expiration dates
