Hello,

I would like to know if it is possible to write a formula to do the
following. And, if it were possible, how would I write that formula?

I would like to highlight a cell with a certain color if the current date is
greater than or equal to a certain date AND time. If it is not yet that
time, then I would like to leave the cell color €œblank€�.

How would I do that? Thanks in advance to whomever may be able to help me.

Candy

In Conditional Formatting.

Formula is =$G$4=DATEVALUE("12/13/2009 12:30:00")

G4 can be active cell or referenced cell.


Gord Dibben MS Excel MVP

On Sun, 13 Dec 2009 10:58:01 -0800, Candy
wrote:

Hello,

I would like to know if it is possible to write a formula to do the
following. And, if it were possible, how would I write that formula?

I would like to highlight a cell with a certain color if the current date is
greater than or equal to a certain date AND time. If it is not yet that
time, then I would like to leave the cell color “blank”.

How would I do that? Thanks in advance to whomever may be able to help me.

Candy

Having an afternoon nap here<g

Disregard those instructions.

Best to place your target date and time in a cell.

Say A1 has 12/14/2009 11:30:00

Enter =NOW() in B1

CF B1 to =B1=A1

Of course you will have to doing something to force a calculation.


Gord

On Sun, 13 Dec 2009 12:33:24 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

In Conditional Formatting.

Formula is =$G$4=DATEVALUE("12/13/2009 12:30:00")

G4 can be active cell or referenced cell.


Gord Dibben MS Excel MVP

On Sun, 13 Dec 2009 10:58:01 -0800, Candy
wrote:

Hello,

I would like to know if it is possible to write a formula to do the
following. And, if it were possible, how would I write that formula?

I would like to highlight a cell with a certain color if the current date is
greater than or equal to a certain date AND time. If it is not yet that
time, then I would like to leave the cell color “blank”.

How would I do that? Thanks in advance to whomever may be able to help me.

Candy