Apr 27 2021 12:53 PM
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.
Apr 27 2021 01:05 PM
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.
Apr 27 2021 01:28 PM
Apr 28 2021 03:50 AM
@WCTMO , you are welcome