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.