Keegan4123
New Member
- Joined
- Mar 30, 2022
- Messages
- 29
- Office Version
- 2016
- Platform
- Windows
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???
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???
Last edited: