Highlight if in Named Range

[crazyforexcel]

Hello,

On the Monthly Analysis sheet I would like to apply the text color to the events that I put in the upper right for the Named Ranges.

For instance the Holidays would be purple text color in the calendar days.

Is this possible to do?

I have Named Ranges:

SpecialOccasions
BillsDue
Holidays
PayDays

Thank you very much for your help

[6StringJazzer]

Your Holiday named range is discontiguous, so I can't think of a way to get that to work. I suggest you make it

Please Login or Register  to view this content.

then the following directions will work. You have the same issue with PayDays.

The easiest thing to do is to see if the name of the event in the calendar is found in the corresponding named range.

Select the event cells in the first day (G7:G11) and create the following rule for Holidays:

Please Login or Register  to view this content.

and set up the color you want for holidays. Repeat for the other named ranges.

Now use the format painter, copying from G7:H11 and painting the format to every other day in the calendar.

[crazyforexcel]

Thank you I just found the same thing being discontinuous.

I didn't realize that it matters.

[6StringJazzer]

My solution uses MATCH which won't work with discontinuous ranges. There might be other solutions that do.