Please help wise people!
I have a grid of cells that will be shaded by the user (on double click they'll scroll through four colours to highlight as they need). I'm wanting to record this information based on the shading in separate cells. Ie. If cell was shaded 'good green' then record a '1', if cell was shaded 'middle yellow' then record a '2', if cell was shaded 'bad red' then record a '3'.
Can anyone help with a formula or similar? Appreciate any support!
I have a grid of cells that will be shaded by the user (on double click they'll scroll through four colours to highlight as they need). I'm wanting to record this information based on the shading in separate cells. Ie. If cell was shaded 'good green' then record a '1', if cell was shaded 'middle yellow' then record a '2', if cell was shaded 'bad red' then record a '3'.
Can anyone help with a formula or similar? Appreciate any support!