Excel 2003: Conditional Formatting
 

I want to change the background color of cells where the cell date is less
than or equal to the current date. How do I put in the current date in the
formula?

Excel 2003: Conditional Formatting
 

Using the function TODAY()
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"oceanmist" wrote in message
...
I want to change the background color of cells where the cell date is less
than or equal to the current date. How do I put in the current date in
the
formula?

Excel 2003: Conditional Formatting
 

So what do I put in the brackets? I guess I type in

TODAY( )

But what do I put in the brackets?

"Bernard Liengme" wrote:

Using the function TODAY()
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"oceanmist" wrote in message
...
I want to change the background color of cells where the cell date is less
than or equal to the current date. How do I put in the current date in
the
formula?

Excel 2003: Conditional Formatting
 

Nothing

=TODAY() will return current date.

=NOW() will return current time.


Gord Dibben MS Excel MVP


On Wed, 20 Sep 2006 11:16:01 -0700, oceanmist
wrote:

So what do I put in the brackets? I guess I type in

TODAY( )

But what do I put in the brackets?

"Bernard Liengme" wrote:

Using the function TODAY()
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"oceanmist" wrote in message
...
I want to change the background color of cells where the cell date is less
than or equal to the current date. How do I put in the current date in
the
formula?