I have created my own conditional formating.

Condition 1 Cell value is greater than =$F$14, colour red
Condition 2 Cell Value is greater than =$G$14, colour orange
Condition 3 Cell Value is equal to 0, colour blue

I want to apply this to the entire Q column so that it applies to all:

Condition 1 Cell value is greater than =$F$15, colour red
Condition 2 Cell Value is greater than =$G$15, colour orange
Condition 3 Cell Value is equal to 0, colour blue

At the moment all of column Q is looking for F14 and G14?

Any help on this would be greatly appreciated.

Thanks.

Neil.