misstoffeepenny
New Member
- Joined
- Jan 18, 2021
- Messages
- 4
- Office Version
-
- 2016
- 2011
- Platform
-
- Windows
hi all, I am trying to conditionally format a multi-date spreadsheet based on whether the month and year is passed this month and year.
eg. if a certificate is passed it's expiry date then highlight red, if its due to be renewed in the next month highlight yellow
I only have the cells formatted in mm/yy eg. feb-21
I have gotten the cells to format for the upcoming month but cannot get the expired dates to format.
can some help please?
note also some cells show n/a instead of a date as they do not apply to a particular site, I want these to have no formatting
eg. if a certificate is passed it's expiry date then highlight red, if its due to be renewed in the next month highlight yellow
I only have the cells formatted in mm/yy eg. feb-21
I have gotten the cells to format for the upcoming month but cannot get the expired dates to format.
can some help please?
note also some cells show n/a instead of a date as they do not apply to a particular site, I want these to have no formatting