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