Using Conditional Formatting for Multiple Cells

[mikecollins08]

I am trying to use conditional formatting for multiple cells. For every Friday, I would like to highlight red the ones that is our off Friday. I use a table of dates that I want to match against to highlight the red ones. Only one day gets highlighted. I thought I read that I can use the one formula for multiple cells but cannot remember how. Can someone tell me how to make it highlight all Fridays that are off days.

Conditional format formula

Table to compare against.

13 Jan highlights correct. 27 January should also show red.
The Friday days are F8, F10, F12, F14, F16, F18

 

[Fluff]

Try it like

=countifs($AE$8:$AE$33,F8)

 

[mikecollins08]

Thank you, it seems to work by selecting all Fridays and creating the conditional formula using your solution.

 

[Fluff]

You're welcome & thanks for the feedback.