conditional formatting and formulas for gantt charts

[sdegr001]

I've got a Gantt chart in Excel (see picture). I'm wanting to create a Cond Form rule that will highlight the cells black that correlate with the date in column E.
For example; in the screenshot I would want cells U9, AC10, AV10, AC11-AE11 all black. This would essentially show that the associate is busiest on those days and cannot take on any other time commitments.

What formula can I put into Cond Form to highlight cells referenced in column E black in the Gantt chart. Any help is appreciated.

[Pete_UK]

A picture is not much use to us - it is better to attach a sample Excel workbook. The yellow banner at the top of the screen explains how you can do this.

Pete

[sdegr001]

I've attached the workbook. Thanks!!

[Pete_UK]

You have shown those "busy" dates in a variety of ways - as a single date, as multiple individual dates separated by a comma, and as a date range separated by a hyphen, and presumably combinations of these formats. They do not lend themselves very easily to be picked up as individual dates. I suggest you list them against each person in a separate sheet, and that might make it a bit easier.

Hope this helps.

Pete

[sdegr001]

Okay, I can do that. What formula would you use for conditional formatting to make cells black based on those dates.

[Pete_UK]

Well, we have to get that other sheet sorted out first. Do you intend to put the person's name in cell B8, and then for the following rows to apply to him/her? Would you then put a second person's name in B14, and so on?

Pete