Hi all,
Not sure if this is possible but I have a sheet which is is broken up by datasets in 5 different colors. Every month the numbers will change which will cause some data to drop into a different color area. I presently have a Rank formula in the sheet but next month when I re rank the sheet some data may now be in a different color area. The question is, is there a way to lock in the background color so even if I filter a name or data only the data changes and not the color? I have attached a screenshot so it may help with what I am talking bout. Thanks all!
Bookmarks