colours in spread sheets

L

Llanelli lad

I am trying to set up a spread sheet but i want to use colours to aid this
ie: 75%+green 50%-74% amber 49% - red can you tell me how to put this into
action
Regards Andie
 
G

Gord Dibben

Check out help on Conditional Formatting and Icon Sets(if using 2007)


Gord Dibben MS Excel MVP

On Mon, 16 Mar 2009 14:59:01 -0700, Llanelli lad <Llanelli
 

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

Similar Threads

Bugs in Office 2019 0
Linking Spread Sheets 1
Bug ?? - Excel 2007 Format Wizard formats values incorrectly (icon 1
2007 conditional formatting not playing ball 5
How do I lock the colours in a chart (red, amber, green) 2
Using Pivot Table Data Values to Create Formulas 0
How do i define cells in different colours 1
Combining multiple spread sheets into one 2

Top