G
Graeme Wallace
Hi,
I wish to create a means of automating my cell shading - ie, I have a
spreadsheet which uses a cell shaded either "red", "yellow" or "green"
depending on its status.
At present, when I enter in more data, I have to click on that cell, and
then select the shading colour - a little boring and slow.
I tried a Drop Down list, but that only uses text and no colour. Is there a
way I can do this?
I am a novice - so simple instructions are a must!!
Thanks.
I wish to create a means of automating my cell shading - ie, I have a
spreadsheet which uses a cell shaded either "red", "yellow" or "green"
depending on its status.
At present, when I enter in more data, I have to click on that cell, and
then select the shading colour - a little boring and slow.
I tried a Drop Down list, but that only uses text and no colour. Is there a
way I can do this?
I am a novice - so simple instructions are a must!!
Thanks.