Forum Discussion

Copper Contributor

Apr 27, 2021

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

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.

Live Tracker.xlsm23.7 MB

Excel for web

3 Replies

SergeiBaklan
Diamond Contributor
Apr 27, 2021
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.
Live Tracker.xlsm23.8 MB
- WCTMO
  Copper Contributor
  Apr 27, 2021
  Worked! Thank you Sergei!
  - SergeiBaklan
    Diamond Contributor
    Apr 28, 2021
    WCTMO , you are welcome