Automatic Colour Fills
 

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.

Automatic Colour Fills
 

check out conditional formating in Help.

<format<conditional formating

"clatters69" wrote:

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.