Forum Discussion

Copper Contributor

Jan 17, 2019

Solved

Create 'incell' 5 day gant with diff colors to show office, home but working, not available

Hello! I'd like to create an overall manpower chart with coloured symbols to give an at a glance idea of whether the staff is 1. working from office (dark green) 2. working from home (light green...

SergeiBaklan
Jan 18, 2019
I guess that's only with VBA programming. As variant the code will analyse the cell below, depends on combination of symbols combine Wingding font blocks with their own colors into one text and return it to your cell, formatting it as Wingding.

manosh

Copper Contributor

Jan 18, 2019

Thanks Sergei.

I was avoiding putting each day in a column since i have

1. other references in cells above which breaks up into non adjacent cells

2. there are numerous days that i have to consider in the programme.

Can you suggest any other way that makes in cell with 5 block symbols to indicate days... that would really help!

thanks

SergeiBaklan

Diamond Contributor

Jan 18, 2019

I guess that's only with VBA programming. As variant the code will analyse the cell below, depends on combination of symbols combine Wingding font blocks with their own colors into one text and return it to your cell, formatting it as Wingding.