Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Condiional Format Question
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Condiional Format Question
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") -- David Biddulph "Jeremy" <jeremiah.a.reynolds @ gmail.com wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Yet Another Name Format Question | Excel Discussion (Misc queries) | |||
Format question | Excel Discussion (Misc queries) | |||
Format Question | Excel Discussion (Misc queries) | |||
Format Question | Excel Worksheet Functions | |||
Format question | Excel Discussion (Misc queries) |