Hi,
use conditional formating, where the formula is, in the first option enter

=A2<=10

choose green
2nd option

=And(A210,A2<30)
choose yellow

third option enter

=A230

choose red

"Duey" wrote:

Hi,
i'm doing some MPG calculations at the moment and using a formula from a
seperate worksheet which then displays on the first worksheet (="You average
"&Round(&Sheet2!A4,2)&" MPG") and i want to format that cell (that displays
the "Your Average is xx.xx MPG) so that if, for example, my average MPG is
<=10 then the whole cell is red, 10 <30 Yellow and 30 Green

i hope this makes sense...

Cheers for your help