Conditional Formatting Calendar

[ltjackson]

Afternoon!

I've been working on a visual calendar recently and have ran into a roadblock. Basically I've got a spreadsheet where column B has names of employees and columns C/AG are in a table format showing a calendar. I'm using a formula in conditional formatting to display days that employee has something scheduled. So I have another sheet that has 2 columns with a start date and an end date. The formula I'm using currently works but it only returns the first instance of that employees name.

Most of the employees in this list have their names appear quite a few times, I need this formula to display all of their dates not just the first return.

Here's the formula I'm using for the group of cells,

=AND(C$17>=INDEX(data_pull!$D$2:$D$1000,MATCH($B19,data_pull!$P$2:$P$1000,0)),C$17<=INDEX(data_pull!$E$2:$E$1000,MATCH($B19,data_pull!$P$2:$P$1000,0)))

C$17 is the row with the months dates which is looking in "data_pull!" at column D for start and column E for end. $B19 is the list of employee names looking for them in the same sheet on column P.

If any additional explanation is needed please let me know.

Thanks a ton!

 

[etaf]

would using a countifs()
for the conditional formatting
So you would use the count to match the Employer name and then also count the calendar date start and end with the list and get a TRUE that way