Hey guys,
I am wondering if there is a way to automatically have my conditional formatting columns (see attachment) automatically update the data they are comparing to. Let me try to make it a little more clear. Each week I make a new spreadsheet and want to compare it to the prior sheet's results. I have just been making a copy of the old spreadsheet and then changing the formula manually in each of the columns. Is there a way so that next week when I create 3.13.12, it will automatically compare itself to 3.6.12?
Thanks a lot in advance!
Bookmarks