| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change font color for row | New Users to Excel | |||
| not able to see font color change. | Excel Discussion (Misc queries) | |||
| how can I conditionally change font color, or background color? | Excel Worksheet Functions | |||
| How to change the default Border, Font Color, and Cell Color | Excel Discussion (Misc queries) | |||
| Change the Font Color | Excel Worksheet Functions | |||
Linear Mode
