May 10, 2022
July 16, 2010
If you look at my Project Management dashboard you can modify it so that the Project name appears in the highlighted cells instead of just a cell fill. You can't have multiple projects on one line, as you have in the case of Mickey Mouse in row 5. It would be very difficult to do this with formulas too, so I think that's a compromise you'd have to make either way you approach this.
Hope that points you in the right direction. Come back if you're stuck with anything.