How to highlight cells if less than the time NOW. Need help.

%3CLINGO-SUB%20id%3D%22lingo-sub-2299468%22%20slang%3D%22en-US%22%3EHow%20to%20highlight%20cells%20if%20less%20than%20the%20time%20NOW.%20Need%20help.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2299468%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20highlight%20any%20time%20in%20column%20G%20that%20is%20less%20than%20the%20current%20time%20(NOW)%20AND%20where%20the%20K%20value%20is%20Ongoing.%26nbsp%3B%20I've%20searched%20and%20searched%2C%20but%20have%20not%20been%20able%20to%20figure%20it%20out.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2299468%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2299536%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20highlight%20cells%20if%20less%20than%20the%20time%20NOW.%20Need%20help.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2299536%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F573650%22%20target%3D%22_blank%22%3E%40WCTMO%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20could%20be%20conditional%20formatting%20rule%20with%20formula%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3D(%24G7%3CMOD%3E%3C%2FMOD%3E%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E(first%20in%20attached%20file).%20NOW()%20returns%20both%20date%20and%20time.%3C%2FP%3E%0A%3CP%3EI%20the%20tag%20you%20added%20%22Excel%20for%20Web%22%20is%20due%20to%20misprint.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I need to highlight any time in column G that is less than the current time (NOW) AND where the K value is Ongoing.  I've searched and searched, but have not been able to figure it out.

3 Replies

@WCTMO 

It could be conditional formatting rule with formula

=($G7<MOD(NOW(),1))*($K7="Ongoing")

(first in attached file). NOW() returns both date and time.

I the tag you added "Excel for Web" is due to misprint.

Worked! Thank you Sergei!