Conditional Formatting

[gdrowell]

I have a worksheet that looks for a date and name match and creates a list from the table.

{=IFERROR(INDEX('Driver Vacations'!$F:$F,SMALL(IF('Driver Vacations'!$K$3:$R$307=January!E$4,ROW('Driver Vacations'!$K$3:$R$307)),ROWS(January!E$5:E16))),"")} where $K$3:$R$307 is the table range.

I want to conditional format any match that occurs in $Q$3:$R$307 without disrupting the original formula above

Any help with be greatly appreciated. Thank you in advance

 

[jasonb75]

In that case, you need the first formula in my previous reply

Try applying one of these as a conditional format rule to the range $I$3:$P$9 The bold 3 refers to the week number.

=INDEX($C$3:$E$9,MATCH(I3,$A$3:$A$9,0),3)=I$2

As I said, the second suggestion was probably me overthinking it.

 

[gdrowell]

This worked Perfectly. Thank you very much. I learned something for sure. Happy New Year to you and yours.