View Single Post
 
Old 04-10-2024, 01:51 PM
DOLOMITE73 DOLOMITE73 is offline Windows 11 Office 2021
Novice
 
Join Date: Apr 2024
Posts: 1
DOLOMITE73 is on a distinguished road
Question 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?
Reply With Quote