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

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

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

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

Yes it worked Thankyou.
What if I want do not want the next cell but 3 or 4 cell over, like D1 or E2?

"Ron Coderre" wrote:

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

Time to get familiar with the OFFSET function, Roger <g

Excel Help does a pretty good job of explaining it.

Post back with any questions.
***********
Regards,
Ron

XL2002, WinXP


"Rodger" wrote:

Yes it worked Thankyou.
What if I want do not want the next cell but 3 or 4 cell over, like D1 or E2?

"Ron Coderre" wrote:

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

Sorry about mis-spelling your name, Rodger : \

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

XL2002, WinXP


"Ron Coderre" wrote:

Time to get familiar with the OFFSET function, Roger <g

Excel Help does a pretty good job of explaining it.

Post back with any questions.
***********
Regards,
Ron

XL2002, WinXP


"Rodger" wrote:

Yes it worked Thankyou.
What if I want do not want the next cell but 3 or 4 cell over, like D1 or E2?

"Ron Coderre" wrote:

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