Using conditional formatting when reference cells contain an array formula in a calandar

[mpost54]

Trying to format the 1st and 3rd Tuesday of each month in a different color - also some individual days
The calendar has an array formula in each cell which is custom formatted to 'd'
Test results shown of my attempts to use cell 'o7' as a reference.
Any help greatly appreciated

[Bo_Ry]

Please try CF formula applies to O6:U11

=O6=WORKDAY.INTL($O$4-1,1,"1011111") > for 1st Tuesday

=O6=WORKDAY.INTL($O$4-1,3,"1011111") > for 3rd Tuesday

[6StringJazzer]

The 1st and 3rd Tuesday is easy, implemented as CF in your file.

Please Login or Register  to view this content.

I can't sort out what you mean by this

and also some individual days such as 1/7/2019

which sounds kind of random.

[mpost54]

Hi Jeff
The 1st part of my question was to conditionally format every 1st and 3rd Tuesday which Bo's formula achieved - I have not tested your answer yet.
I also would like to conditionally format some individual days in the calendar such as 01/07/2019 - there will be others.
They are individual days that a particular event will occur and will include a start date and end date for the event.

Michael

[mpost54]

Hi Jeff
Have now looked at your formula - and it works well too for the 1st and 3rd Tuesday!
Now just need the second part explained in previous post.

Michael

[6StringJazzer]

I also would like to conditionally format some individual days in the calendar such as 01/07/2019 - there will be others.

Your example file did not show how you will specify what those days are.

[mpost54]

Hi Jeff
What I mean by individual days is, on the 1/7/2019 a 'member fee renewal' would become due and the last day for 'payment' would be 31/08/2019.
Therefore I would like to recolor these two dates on the calendar from grey to say red.
Just the two individual dates and not the range between the two dates.
So with calendar set to July recolor cell 'o7' and then with the calendar set to 'August' recolor cell 's11'
Thanks for your patience on this one.

Michael

[Bo_Ry]

J11 = 1/7/2019

Please try CF formula applies to O6:U11

=O6=$J$11 fill grey

=O6=EOMONTH($J$11,1) fill red

[mpost54]

Just got to your reply Bo and this will do the trick.
Great solution once again.
In my opinion you are one of the most valuable contributors to this forum.
I will now mark this as solved.

[Bo_Ry]

Thank you for your kind comment