Can I use the date in conditiional formating?

[gargoyle]

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

 

[Bob Phillips]

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)

 

[Gord Dibben]

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

Format>Conditional Formatting>Cell 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 Format>Patterns.

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

Format>Conditional Formatting>Formula is: =$A1>TODAY()

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

 

[Gord Dibben]

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

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)

Gord Dibben MS Excel MVP

 

[gargoyle]

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

 

[Gord Dibben]

Thanks for clearing that up.

Another one for Bob<g>


Gord