Conditional Formatting - Excel 2003

N

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.
 
J

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top