Conditional formating: Compare two columns with Inserted lines

T

Tim

I have two coloumns of numbers, (A&B).
Some numbers in B match the ones in A.
A has more numbers then B.

I need to insert lines into B to get them to line up with A.
I use Conditional Formatting to let me see when the numbers match.

Problem:
When I insert a cell in B, the reference to A does not move down.
The cell reference is in the format =A1, NOT =$A$1.

Excell 2000 allowed this to work.
Excell 2003 does not seem to.
 
B

Biff

Hi!

Try setting the cf to column A:

=A5=OFFSET(A5,0,1)

When you insert cells in column B and the numbers match then the
corresponding cells in column A will show the cf.

Biff
 
Top