T TGS Jun 22, 2008 #1 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?
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?
E Ed Ferrero Jun 22, 2008 #2 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
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
T TGS Jun 22, 2008 #3 Merci, Ed -- TGS Ed Ferrero said: 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 Click to expand...
Merci, Ed -- TGS Ed Ferrero said: 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 Click to expand...
