customize calendar (some dates in red color) in excel
 

In my personal.xls I have a calendar (in userfrom). Now all the dates are of
same color. Is it possible to show some dates (for example: Jan 26, Aug 15,
Dec 25 etc) in red color with bold fonts while the rest of the dates remain
untouched.

Use Windows XP prof with Excel 2002
Any suggestions highly appreciated.

customize calendar (some dates in red color) in excel
 

I guess it would depend on what the calendar is. If it is a single control,
then you would need to see what the capabilities of the unnamed control are.
If you have cobbled something together with textboxes and/or labels, the
certainly you can use the forecolor property to change the font color.

--
Regards,
Tom Ogilvy


"shajueasow" wrote in message
...
In my personal.xls I have a calendar (in userfrom). Now all the dates are
of
same color. Is it possible to show some dates (for example: Jan 26, Aug
15,
Dec 25 etc) in red color with bold fonts while the rest of the dates
remain
untouched.

Use Windows XP prof with Excel 2002
Any suggestions highly appreciated.