Condiional Format Question

[Jeremy]

I am working on a contact timing spreadsheet. I have a column for a date and
time of 'closed out contact'. The column will contain =NOW() until the
person is in the cell and hits F2 then F9 and locks in the current time. I
need the cell in G2 to change depending on whether or not the below
conditions are met. I am not vvery good with conditional formatting. Can
someone help me?

If E2 = NOW() then H2 = NO

If E2 <> NOW then H2 YES

 

[David Biddulph]

It's not a conditional formatting question, as you are changing the
*content* of the cell, not its format.

In H2 (or G2, depending on which you want), put the formula
=IF(E2=NOW(),"NO","YES")