Hoow do I create a macro to change font color

Microsoft Excel 2003 (full product)
May 12, 2010 at 07:47:12
Specs: Windows XP
I would like to create a macro which would change font color to red when dates are within 4 months of current date. Any code or info would be GREATLY appreciated.

See More: Hoow do I create a macro to change font color

Report •

May 12, 2010 at 08:26:38
What not use Conditional Formatting instead of a macro?

Format...Conditional Formatting...Formula is

Use something like this:


Click the Format button and set the Font Color

Report •

May 13, 2010 at 04:38:34

Here are some more detailed instructions on applying the formula DerbyDad03 suggested:
From the Menu select 'Format' and then 'Conditional Formatting...'
In the dialog box, from the Drop-down list under 'Condition 1' select 'Formula Is'
Enter the formula in the box to the right of 'Formula Is'


(You can use Ctrl V [Control Key and V pressed together] to paste a copied formula into the box)
Note that TRUE and FALSE do not have double quotes - they are Excel's logical values true and false.
Click the 'Format ...' button and select the appropriate Tab, e.g., Font or Patterns (for cell background), click OK
Click OK again (or 'Add>>' to add a further formula and format).


Report •

May 13, 2010 at 06:17:56
Thanks. That worked!

Report •

Related Solutions

Ask Question