Conditional formatting based on 3rd Friday of Month.

[deanldavis]

I am attempting to do a conditional formatting of the cell that contains the date of the 3rd Friday of each month. I currently have 2 columns, one containing the date of the weekday of the current row and a column containing the symbol of the day of the week based on the value returned for the value of the first column (1 = M, 2 = T, etc). I want to color the 3rd friday of each month different from all of the other dates of the month. Any help here??
Thanks
Dean

 

[platonic567]

Do you have a column with all the dates in Excel Date format?

 

[deanldavis]

Do you have a column with all the dates in Excel Date format?

Yes I do

 

[platonic567]

Yes I do

Use this formula for conditional formatting, adjust column as required

=AND(DAY(F1)>=15,DAY(F1)<22,WEEKDAY(F1)=6)

 

[deanldavis]

Oh You are so clever. Thank you very much.

 

[platonic567]

You're welcome!