customize calendar (some dates in red color) in excel

G

Guest

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.
 
T

Tom Ogilvy

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.
 

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

Color Cells 3
Calendar 1
Search and change font color to Red and bold it 1
excel won't sort dates correctly 0
macro to color all text red in worksheet if within certain date 3
2007 Calendar bold dates hard to see 3
Logic Formula using colors in the formula? 2
Calculate End Date Using Start Date and No. of Days excluding specific days. 0

Top