Can I use the date in conditiional formating?
 

I want anything past todays date to highlight in red. How do I do that?
(can I do that?)


--
gargoyle
------------------------------------------------------------------------
gargoyle's Profile: http://www.excelforum.com/member.php...o&userid=37121
View this thread: http://www.excelforum.com/showthread...hreadid=568535

Can I use the date in conditiional formating?
 

Change the condition to Formula Is and add a formula of

=A1<TODAY()

then format, assuming that A1 is the target cell.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"gargoyle" wrote in
message ...

I want anything past todays date to highlight in red. How do I do that?
(can I do that?)


--
gargoyle
------------------------------------------------------------------------
gargoyle's Profile:
http://www.excelforum.com/member.php...o&userid=37121
View this thread: http://www.excelforum.com/showthread...hreadid=568535

Can I use the date in conditiional formating?
 

Select a range of cells to format, say A1:A100

FormatConditional FormattingCell Value is: greater than =TODAY() and hit OK

Watch out for that one. Excel will turn it into ="TODAY()"

Pick again and edit out the " marks

Format to Red from FormatPatterns.

OR............................

FormatConditional FormattingFormula is: =$A1TODAY()

Both the same but I prefer the Formula is in most cases.

There are so many more options when using the Formula is:


Gord Dibben MS Excel MVP

On Fri, 4 Aug 2006 18:26:03 -0400, gargoyle
wrote:


I want anything past todays date to highlight in red. How do I do that?
(can I do that?)

Can I use the date in conditiional formating?
 

I always think of "past" today as after today but maybe OP wants "past" dates
which would be before today.

Maybe we'll find out.<g

Hope so.


Gord

On Sat, 5 Aug 2006 00:04:10 +0100, "Bob Phillips" wrote:

Change the condition to Formula Is and add a formula of

=A1<TODAY()

then format, assuming that A1 is the target cell.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"gargoyle" wrote in
message ...

I want anything past todays date to highlight in red. How do I do that?
(can I do that?)


--
gargoyle
------------------------------------------------------------------------
gargoyle's Profile:
http://www.excelforum.com/member.php...o&userid=37121
View this thread: http://www.excelforum.com/showthread...hreadid=568535


Gord Dibben MS Excel MVP

Can I use the date in conditiional formating?
 

Went with 'less than' as I wanted everything that was 'past-due' to show
up in red. Thanks everyone.


--
gargoyle
------------------------------------------------------------------------
gargoyle's Profile: http://www.excelforum.com/member.php...o&userid=37121
View this thread: http://www.excelforum.com/showthread...hreadid=568535

Can I use the date in conditiional formating?
 

Thanks for clearing that up.

Another one for Bob<g


Gord

On Sun, 6 Aug 2006 06:19:35 -0400, gargoyle
wrote:


Went with 'less than' as I wanted everything that was 'past-due' to show
up in red. Thanks everyone.