auto change cell colour based on date

Copper Contributor

hi everyone, 

 

please help!I need the cell date to change to red text when the current date passes. 

If i put in a future expiry date, then when the date entered is now today or has passed, i need the text date to turn red so i know the date for that staff members certification has now expired. 

 

How do i do this? 

 

thank you!

1 Reply

@Bella A 

You may apply conditional formatting rule with formula like

=A1>TODAY()