I have a project where we are trying to display a list of projects with defined steps and statuses. In excel, we are currently using conditional formatting of cells, not really the best way, but it does provide a glance and the status of each line.
The rows have the project name and the Columns have the milestones,( Currently 5 defined.) Each intersecting cell is colored based on the status of "On Track", "Slipping","Off Track", "On Hold", "Done" and "Not Started".
Any ideas on what visuals I can use to best display project status? I keep running into issue where I can't control conditional formatting to display properly. I am also open to a fresh idea of how the effectively show the project status in a new format that would include the project and predefined milestones. I did try the custom "Table Heat Map" and that was close, but just didn't look polished enough.