conditional formatting when two cells match and it has passed a specific date

[RSnap3232]

Hello All,

I am trying to do a conditional format where if cells in E36 and E37 match and we have passed a specific date (in this case 31/01/2021) it will turn green, is this possible?

 

[wiseone]

=AND(E36=E37, Today()>44308)

Today() is today's date which will update everytime you open the file. 44308 is the date you specified in number form. You could use a cell reference as well for the date criteria. for example:

=AND(E36=E37, Today()>$A$1)

Where A1 is a cell in your sheet with a date specified.

 

[RSnap3232]

=AND(E36=E37, Today()>44308)

Today() is today's date which will update everytime you open the file. 44308 is the date you specified in number form. You could use a cell reference as well for the date criteria. for example:

=AND(E36=E37, Today()>$A$1)

Where A1 is a cell in your sheet with a date specified.

thank you kindly.