Try something like this:

For B1's CF criteria....
Formula is: =AND(B1<"",B1=OFFSET(B1,0,-1))

That criteris will always compare agains the contiguous cell to the left of
the CF cell and is durable agains inserting cells, copying, and moving.

Note: it will not work in Col_A, though (no cells to the left!)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Rodger" wrote:

My settings are in cell B1 I put a conditional format of (equal to) (=a1)
format. Then if I insert a cell into B1 down the condition format in cell B2
has the same condition format as B1 did when I want it to be (equal to) (=a2)
in cell B2.

"Ron Coderre" wrote:

If you post your actual Conditional Formatting settings, we'll have a better
handle on the issues you're encountering.

***********
Regards,
Ron

XL2002, WinXP


"Rodger" wrote:

I am using conditional formation to match values from on cell to another. I
place my conditional formatting in Column B to match the values in column A
but when I insert a cell in B the conditional formation does not change with
how many cells I insert, like in the old version of excel. How do I get the
conditional formatting to change after inserting a cell(s)?
Thank you