Conditional formatting based on two cell results

[Molecheese]

Hi,

I'm sure this is pretty simple, but I cant figure it out!

I have a cell which I want to colour green if C6>9, yellow if O6>60 and red if BOTH C6 and O6 are above their respective numbers. The first two parts of this are obviously straight forward, but I cant work out how to get the third part of it to work.

Any help will be gratefully received!

Thanks
M

[NBVC]

Formula 1:

=AND(C6>9,O6>60) formatted Red

Formula 2:

=O6>60 formatted yellow

Formula 3:

=C6>9 formatted as green

[Molecheese]

Thanks very much - this works perfectly!