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.

Below are the different reference styles. Choose as required..

A1 Relative referencing. Both column and row will change if you copy or drag
the formula.
$A1 The column reference is fixed and will not change
A$1 The row reference is fixed and will not change.
$A$1 Column and row reference are fixed.

--
Jacob


"Neil Holden" wrote:

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.

Yet again Jacob, thanks alot!!

I should have known that!!

Neil.

"Jacob Skaria" wrote:

Below are the different reference styles. Choose as required..

A1 Relative referencing. Both column and row will change if you copy or drag
the formula.
$A1 The column reference is fixed and will not change
A$1 The row reference is fixed and will not change.
$A$1 Column and row reference are fixed.

--
Jacob


"Neil Holden" wrote:

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.