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

Copper 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!