Drop Down Shading
You can use conditional formatting to change colour automatically. In
Excel 2003 and earlier you are limited to 3 conditional formats in
each cell (which is what you describe), in Excel 2007 I think the
limit is 64.
If you tell us what your status conditions are (and which cells/
columns) then we can give you more detailed instructions.
Hope this helps.
Pete
On Apr 28, 11:21*am, Graeme Wallace
wrote:
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.
|