Hi,
I have a spreadsheet with 24 different tabs. 22 of them are color coded based on cell colors in the first tab. For instance, the 3rd tab is currently yellow because in the first tab, cell E4 is yellow. The 4th tab is currently red because in the first tab, Cell E5 is red. The 5th tab is currently yellow because in the first tab, Cell E6 is yellow...etc. The cells will either be red (high priority), yellow (medium priority), or blue (low priority). I will change the cell colors on the first tab from time to time, depending on the priority. I want the tab colors to change automatically when I change the cell colors. Is this possible?
Bookmarks