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) 3. not available. Currently i have a helper cell where i can quickly type out "O", "H", "X" but i'd like my display cell to convert this into an appropriate coloured block which is visually more appealing. Typical weeks might be 1. OOOOO - working in office for 5 days - solid dark green block 2. HHOOX - work two days from home, two days in office and not available - Light green x 2 blocks, Dark green x 2 blocks and a red block. Visual example attached. Currently i am formatting the display cell manually, but as staff movement changes its quite tedious. I would have done a unique cell for each day but it makes for a long table so went with the incell approach. Any help would be appreciated.
