Drop Down Shading

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.
 
P

Pete_UK

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
 
G

Graeme Wallace

Thanks Pete,

I have created a Drop Down list and used the Conditional Formatting -
working brilliant!
At this rate, I will be an Excel Guru!!

Thanks again.
 
P

Pete_UK

Well, there's a lot of them about on this board !! <bg>

Glad to hear that you got it working - thanks for feeding back.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top