Related:
- Conditional formatting based on specific expiration date
- Excel date format dd.mm.yyyy - Guide
- Excel conditional formatting if another cell contains specific text - Excel Forum
- Apply conditional formatting to the selected cells ✓ - Excel Forum
- Conditional formatting if two cells match ✓ - Excel Forum
- Do message requests on instagram expire - Guide
2 responses
You do understand, every time you open the worksheet, it will always be 365 days behind. You have to code in the date.
Check this out though for when you get past the date counter problem:
https://ccm.net/forum/affich-910435-conditional-formating-formula-cell-text-change-color
Check this out though for when you get past the date counter problem:
https://ccm.net/forum/affich-910435-conditional-formating-formula-cell-text-change-color
I do understand that my current rule will not solve the problem with the expiration date. I would like to set up a rule that when the date goes beyond September 30, the cell turns red. For instance, if someone were to take a course on August 1, 2015 that is what would be entered into the cell. When we reach any day after September 30, it would turn red. I do not want the cell to turn red after August 1 like my current rule is set up for.
Is there a rule that can be set that says the cell should be turned red when the date in the cell goes beyond a specific month and day?
Thanks!
Is there a rule that can be set that says the cell should be turned red when the date in the cell goes beyond a specific month and day?
Thanks!