Fill-colour a cell dependent on formula

Formula in C1 - =IF(A1<B1,"Green",IF(AQ<B1/0.95,"Red","Amber"))

How can I fill-colour the cell to change to the colour (Green, Amber or Red)
rather than show the word of the colour.

Many thanks in advance.

Take a look at Conditional Formatting in XL Help.


In article <68E046F9-A489-4C1A-BCC1-49692478DAE1@microsoft.com>,
Kim Duffy <KimDuffy@discussions.microsoft.com> wrote:

> How can I fill-colour the cell to change to the colour (Green, Amber or Red)
> rather than show the word of the colour.