Conditional format in gantt charts

Hello,

I'm using one of the pre-existing simple gantt chart templates on excel and I'm trying to alter the conditional formatting rules based on the resources.
I.e I want to be able to select crew 1 or crew 2 in column B (assigned to) (will need about 20 in total, but I can generate a list from data validation) and for it to then colour code the progress bars on the gantt chart according to which crew I've picked.

So if I select crew 1, the duration bars will turn red, crew 2 the bars will turn blue etc etc.

Regards,

Alex

If you expect to have up to 20 different crews, then you will need 20 different CF rules. You can amend your existing rule (for dark blue) to this:

=AND(task_end>=H$5,task_start<I$5,$B7="Hussey crew")

and choose red for the background. You will need to create 19 new rules for the same range for the other crews with appropriate colours.

Hope this helps.

Pete

This is lot of conditional formatting and it will be so colorful at the end.

How about this, if you select team in B column it will make red all other activities of that team, and blue all others.

For example, select B42 and you'll get red in rows 42, 43, 44 and 45.
Select B46 and you'll get red in rows 46, 50 and 62

Hi all,

Thanks for the replies. Zbor, your idea isn't quite what I'm after. Need it more in line with the first couple of ideas, I don't mind adding more formats as I add more crews.

I've added a load in now to the updated one, but some of them aren't applying the rules I've made and I can't work out why.

See rows 91 (should be pink for suprafilt), an 107 downwards (various colours depending on crew selected).

Assuming there's another rule in the worksheet that is taking precedence, but I can't work out which one it is.

Thanks,

Alex

That's the one! Thanks Ali.