Color cell text based on date
 

I need a way to color all dates in a column if the date is later than today.
I can do it using the autofilter, but if there are no late dates, it colors
the whole workbook.

Help.

Byron

Color cell text based on date
 

You can do this with Conditional Formatting on the Format menu.
Select the cells you want to format, change "Cell Value Is" to
"Formula Is" and use a formula like

=A1TODAY()

Change the A1 to the first selected cell.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Byron" wrote in message
...
I need a way to color all dates in a column if the date is later
than today.
I can do it using the autofilter, but if there are no late
dates, it colors
the whole workbook.

Help.

Byron

Color cell text based on date
 

Can this be done with VBA?

"Chip Pearson" wrote:

You can do this with Conditional Formatting on the Format menu.
Select the cells you want to format, change "Cell Value Is" to
"Formula Is" and use a formula like

=A1TODAY()

Change the A1 to the first selected cell.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Byron" wrote in message
...
I need a way to color all dates in a column if the date is later
than today.
I can do it using the autofilter, but if there are no late
dates, it colors
the whole workbook.

Help.

Byron