I put one together in Post #11 of this thread:
https://www.excelforum.com/excel-pro...ck-events.html
which has a similar layout to yours. This uses two colours through conditional formatting, although the colours are dependent on the values in column F.
Although you say that you have up to 30 projects, I don't think it would be necessary to have 30 colours - you could get by with just 2, so that you have alternate colours for each project (which occupy several lines for the different stages, anyway).
Hope this helps.
Pete
Bookmarks