Hello all,
I am having a bit of difficulty with the formula feature on the conditional formatting and was wondering if someone could help. I think I'm in the right direction, but since the arrays are not in sync, the colors are appearing in the wrong location on the calendar. I have attached my calendar below.
Thanks!!
SConditional Formatting - Calendar.xlsx
1st, those are not dates, they are text, looking like dates
to convert them to real dates, highlight the entire range (in column U), click Data tab/Text2Columns/next/next/check Date (MDY)/Finish
Then use this as a New Rule....
=MATCH(C32,$U$30:$U$49,0) format fill as needed
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks