Home

Conditional formatting for date+time

%3CLINGO-SUB%20id%3D%22lingo-sub-859860%22%20slang%3D%22en-US%22%3EConditional%20formatting%20for%20date%2Btime%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-859860%22%20slang%3D%22en-US%22%3EI%20have%20a%20column%20of%20due%20dates%2Btime%20(for%20example%2C%2015.05.2019%2018%3A00).%3CBR%20%2F%3E%3CBR%20%2F%3EI%20want%20to%20see%20cells%20with%20expired%20time%20coloured%20in%20red%20color.%3CBR%20%2F%3EHow%20can%20do%20it%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-859860%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-859875%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20formatting%20for%20date%2Btime%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-859875%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F410582%22%20target%3D%22_blank%22%3E%40Polinaavital%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20your%20dates%20are%20in%20column%20A%20you%20may%20apply%20the%20rule%20to%20it%20with%20formula%20like%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E%3DNOW()%20%26gt%3B%20%24A1%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Polinaavital
Occasional Visitor
I have a column of due dates+time (for example, 15.05.2019 18:00).

I want to see cells with expired time coloured in red color.
How can do it?
1 Reply

@Polinaavital 

If your dates are in column A you may apply the rule to it with formula like

=NOW() > $A1

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies