Additional Symbol Colours

Sarah Butterworth

Hello

Currently there are 5 Symbol colours but you can only use 4 of them. Can you add an addition where you can use all 5. Would be much more helpful when building Project Plans.

Ie, Green = On Track / Yellow = Risk, Project not affected / Red = Risk, project affected / Blue = complete / Grey = Not started

Thank you

Sarah

Paul Newcome

Until this becomes a thing, you can use UNICHAR(11044) to output a black dot which can have the color changed using conditional formatting which allows you to use any of the colors in the Conditional Formatting pallet.

Mariann Carmen

I use emoji's to add additional colors when needed. See example below:

=IF(Status@row = "Not Started", "⚪", IF(Status@row = "In Progress", "🟢", IF(Status@row = "Complete", "🔵", IF(Status@row = "At Risk", "🟡", IF(Status@row = "Behind Schedule", "🔴", IF(Status@row = "Task Deleted", "❌", IF(Status@row = "On Hold", "🟣")))))))