ExcelBanter - change font color

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - change font color (https://www.excelbanter.com/new-users-excel/192158-change-font-color.html)

TGS

change font color

I have a column of dates, and want to change font to red, for the cells that
are < today's date. How can I do this?
--
TGS

Ed Ferrero[_2_]

change font color

Hi TGS,

Format - Conditional Formatting

Set condition 1 to;
Cell Value Is
less than
=NOW() (enter this formula in the box)

Click the format button and format the font to red.

Ed Ferrero
www.edferrero.com

"TGS" wrote in message
...
I have a column of dates, and want to change font to red, for the cells
that
are < today's date. How can I do this?
--
TGS

TGS

change font color

Merci, Ed
--
TGS

"Ed Ferrero" wrote:

Hi TGS,

Format - Conditional Formatting

Set condition 1 to;
Cell Value Is
less than
=NOW() (enter this formula in the box)

Click the format button and format the font to red.

Ed Ferrero
www.edferrero.com

"TGS" wrote in message
...
I have a column of dates, and want to change font to red, for the cells
that
are < today's date. How can I do this?
--
TGS

All times are GMT +1. The time now is 04:07 AM.