Automatic Colour Fills

G

Guest

How do I automatically colour a cell depending on the value within it? I'd
like to colour cells with a value of -1 or less red, cells with a value of 0
yellow and cells with a value of 1 or more green.
 

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

format cells depending on value range 5
Conditional formatting in Excel 2010 2
Question about conditional formatting of zeros in Excel 0
Formate colour of cells 4
Conditional Formatting - Excel 2003 2
Formate colour of cells in a range of raw 3
Count 4
Using 3 coloured Cells to Format a 4th Cell 7

Top