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
{=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