can a macro do conditional formatting?

**anon125-2** · 09-12-2009, 03:28 PM

I have a sheet with 5 calenders, and i would like it if there was a macro that could change the fill color depending on which date group that day fell into.
i would need 5 similar macros.
I say a macro cos there are 5 calenders so a vba thing that covered the whole sheet would not work!
see the picture
i would like to change the dates in the top parts and have the calender day fill colors change accordingly. ( or text colour if that was easier)
each day in the calender does no which date it is!
any ideas folks?
thanks

**royUK** · 09-13-2009, 03:44 AM

Nice picture but it's no help, add an example workbook.

What do you mean by

a macro cos there are 5 calenders so a vba thing that covered the whole sheet would not work!

**anon125-2** · 09-13-2009, 12:57 PM

There are five calenders on the same page.
(the months beneath each other).
i found that when i applied a vba to the whole page it would of course be almost impossible to write it covering 5 separate versions!
there are 5 december 1st etc, each would have to compare themselves with the correct range above.
same for all other dates of course!

http://www.4shared.com/file/13234615..._options2.html

here is the file as requested - it is 3466 KB
thanks

**royUK** · 09-13-2009, 01:02 PM

There's a problem with the downoad link. Why not use the manage attachments button & attach directly to the question?

**anon125-2** · 09-17-2009, 09:25 PM

Originally Posted by royUK

There's a problem with the downoad link. Why not use the manage attachments button & attach directly to the question?

thanks
i did not think it would take a 3mb file!

**shg** · 09-17-2009, 09:29 PM

It won't, but it can't possibly take a 3MB file to illustrate what you're trying to do.

**anon125-2** · 09-17-2009, 11:16 PM

here is a file with one of the five calendars.
strange it is a small file but when i even tried a two calender file it was over 2MB !

the download link works well- so to get the whole file...
thanks