Problem with Multiple Option Button Groups

[dapo]

I stuck on using option button groups. I have created two option button groups and a date cell on a worksheet that I want to use working with 12 monthly calendars. Group 1 has 4 choices (Weekly, Bi-Weekly, Semi-Monthly, and Monthly), Group 2 has 7 choices (days of the week), and then there is the cell to enter a date. What I want to do is make select in Group 1 and Group 2 and enter a date, then have programming set calendar dates (identified in group 1 & 2) font a pre-defined color. For example, if select Weekly in group 1 and Sunday in group 2 and enter date of first Sunday of year, then Sunday of every week will be the pre-defined font color. Or, if I select Bi-Weekly and Friday and enter 1/8/2010 (second Friday of year), then Friday 1/8/2010 and every other Friday is the pre-defined font color. Each of the choices from group 1 seems to present different problems, and I have no idea how to begin programming for the desires results. Any help is so greatly appreciated. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>

 

[wilcowoods]

I'd like to help - sounds like a combination of conditional formatting and some formulas might do the trick without code. But code could be neat too. Can you download or copy your sheet so we can see how things are laid out as I'm not sure what's meant by option button groups ?

 

[dapo]

Wilcowoods,

I do appreciate your offer to help, but as far as I can tell this site want allow me to attach my file. I checked out the FAQ and it said something about using colo's HTML, but when I click on the link, I get message saying "forbidden" and that I don't have access to that. Unless there a way to attach the file through this site, the only other choice I have is to send it to you attached to an email.

Thanks
dapo

 

[wilcowoods]

Hi Dapo

I'm bogged down with work over the weekend so it may be an idea to re-post. May I make a suggestion? If you can't access the download system here just copy and paste an extract of your sheet into the box and people can see what's going on.

I'll come and look for your post next week and try and help should nobody get back to you. Regards Will

 

[dapo]

Bump