Conditional Formatting - Excel 2003

[Neil Holden]

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.

 

[Jacob Skaria]

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.

 

[Neil Holden]

Yet again Jacob, thanks alot!!

I should have known that!!

Neil.