Can I use the date in conditiional formating?

G

gargoyle

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

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)
 
G

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
 
G

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)
Click to expand...

Gord Dibben MS Excel MVP
 
G

gargoyle

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