Related:
- Conditional formatting based on specific expiration date
- How to find specific words on a page - Guide
- Excel conditional formatting based on date - Guide
- How do i find a specific video on youtube - Guide
- Do message requests on instagram expire - Guide
- How to change date format in excel - 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!