Feb 20 2023 01:30 PM
Hi all,
im trying to set up a qualification spreadsheet,
what I’d like to happen is when a specific date has passed in the next 3 years, for the row to go red and the cell on that row in the qualification colour to change to expired, id also like the row and cell to be green and say passed if it has not reached that date.
Any help much appreciated.
cheers
Feb 21 2023 09:03 AM
How to conditional formatting based on date in Excel?
Conditional formatting dates equal to/greater than/older than TODAY
Conditional formatting past dates
Conditional formatting future dates
Conditional formatting between two dates
Conditional formatting based on date in another column+
Hope I was able to help you with these links.