View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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.