Related:
- Conditional formatting based on specific expiration date
- Excel date format dd.mm.yyyy - Guide
- How to find specific words on a page - Guide
- Do message requests on instagram expire - Guide
- Excel conditional formatting if another cell contains specific text - Excel Forum
- We couldn't find an account matching the login info you entered, but found an account that closely matches based on your login history ✓ - Facebook Forum
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!