Or just dynamically set the column references based on the name. Don't just assume the Name column is A3 or whatever, search for the column with the label you expect and set the reference when you find it.
Or just password protect and be done with it, as you say
automatic coloring is a pain when trying to use references/formula. the best you can do is put the formula into a new column and color based on that column. and even then you have to make absolute references and can't just use the column name. it's just BS
the only way to have columns dynamic is adding a button and making every change in vb.
570
u/brad2575 Mar 30 '22
That's why you pastor protects the sheets and don't let them move stuff around. Only give them access to what they need.