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