Using absolute references in a range

[Keegan4123]

This one pains me to post... but I am at a loss how to make this work.

I have a very simple 3 column sheet

Old Name, New Name, TRUE/FALSE

The idea is I have a list of staff on an old list, and a new list, I want to ensure both lists match so I have a simple =a1=b1 type formula to give me true/false with conditional formatting.

I can autofill the true/false all the way down, but then when insert or delete cells to move the list up or down, the formula changes cell references. However if i try to absolute reference the cells, then i can't drag it down and auto fill.

Essentially I want to drag it down with non absolute reference, then change them all to absolute after they are filled. Anyway to do that???

 

[Keegan4123]

Found a work around by using a helper column and using indirect to create a cell reference that never changes, seems like there should be an easier way though.

 

[AquaSky]

Found a work around by using a helper column and using indirect to create a cell reference that never changes, seems like there should be an easier way though.

Thank you give that a try