I am using a Match formula to conditionally format cells on a calendar dashboard.
The calendar has dates 01/01/2016 to 12/31/2016 listed in cells E13 to NC13. When a date from this range is listed in a column on a separate sheet under a persons name I would like the cell to format with a fill. Example listed below.
For example, =MATCH(E$13, 'Sheet2!$B:$B, 0)
The "'Sheet2!$B:$B" is a static reference to a column of a specific person.
I would like to update the Match formula to search for the person's name listed in cell B15 of Sheet 1 (dashboard) instead of referencing Column B:B. This will allow the formula to be dependent on the name listed in cell B15 if I filter the dashboard.
I am currently using the formula `=MATCH(E$13,'Sheet2!$B:$B, 0), 0) and it works great except when I filter the dashboard the formatting is not dependent on the name listed in the cell in Column "B".
Should I be using "Index & Match" for multiple criteria? I am lost, any help would be greatly appreciated.
The calendar has dates 01/01/2016 to 12/31/2016 listed in cells E13 to NC13. When a date from this range is listed in a column on a separate sheet under a persons name I would like the cell to format with a fill. Example listed below.
For example, =MATCH(E$13, 'Sheet2!$B:$B, 0)
The "'Sheet2!$B:$B" is a static reference to a column of a specific person.
I would like to update the Match formula to search for the person's name listed in cell B15 of Sheet 1 (dashboard) instead of referencing Column B:B. This will allow the formula to be dependent on the name listed in cell B15 if I filter the dashboard.
I am currently using the formula `=MATCH(E$13,'Sheet2!$B:$B, 0), 0) and it works great except when I filter the dashboard the formatting is not dependent on the name listed in the cell in Column "B".
Should I be using "Index & Match" for multiple criteria? I am lost, any help would be greatly appreciated.
