Conditional formatting to show if date has passed
In a list of birthdates I'd like to apply conditional formatting so when I open the sheet cells showing birthdays for that year that have passed on that date show green and ones that haven't show red and if they happen to be on that date, say Amber
Example
Open sheet on 10-Apr-2024
Cell value = Colour
01-Jan-2008 = Green
20-Feb-2010 = Green
10-Apr-2010 = Amber
04-May-2011 = Red
24-Sep-2012 = Red
then I open the same sheet on say 11-May-2024
01-Jan-2008 = Green
20-Feb-2010 = Green
10-Apr-2010 = Green
04-May-2011 = Green
24-Sep-2012 = Red
So the formula needs to check the dd-mm have passed but ignore the Year.
Any ideas?
|