change font color

T

TGS

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help modifying code 0
Footer text appears "squished" 1
Font drop-down menu very slow 0
Outlook 365 overriding formatting choices 0
Printing Outline view - formatting lost 0
Descenders clipped 0
How can the font and size of (all) citation numbers be altered? 1
How to modify and updte specific styles for specific paragraphs across the document 0

Top