Home

auto change cell colour based on date

%3CLINGO-SUB%20id%3D%22lingo-sub-712436%22%20slang%3D%22en-US%22%3Eauto%20change%20cell%20colour%20based%20on%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-712436%22%20slang%3D%22en-US%22%3E%3CP%3Ehi%20everyone%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eplease%20help!I%20need%20the%20cell%20date%20to%20change%20to%20red%20text%20when%20the%20current%20date%20passes.%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20i%20put%20in%20a%20future%20expiry%20date%2C%20then%20when%20the%20date%20entered%20is%20now%20today%20or%20has%20passed%2C%20i%20need%20the%20text%20date%20to%20turn%20red%20so%20i%20know%20the%20date%20for%20that%20staff%20members%20certification%20has%20now%20expired.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20do%20i%20do%20this%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-712436%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-714048%22%20slang%3D%22en-US%22%3ERe%3A%20auto%20change%20cell%20colour%20based%20on%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-714048%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F122850%22%20target%3D%22_blank%22%3E%40Bella%20A%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20apply%20conditional%20formatting%20rule%20with%20formula%20like%3C%2FP%3E%0A%3CPRE%3E%3DA1%26gt%3BTODAY()%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
Bella A
New 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()