Fill-colour a cell dependent on formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Back
Top