Forum Discussion
Conditional formatting for expiry dates
Hi, I have been given a training s/sheet to monitor the teams training schedule. I'm wanting it to automatically change colour (like a traffic light system) Amber a month before it expires, and then...
mtarler Thankyou, is there a way it will work using GB date format DD/MM/YYYY?
The date format doesn't matter. The conditional formatting is calculated based purely on the date VALUE. The date FORMAT can be set using the cell formatting. With respect to the default date format and what excel recognizes a date as when typed in, that is based on windows regional settings.