I frequently work in two spreadsheets simultaneously. I highlight in both. My problem is now that we're using Excel 2013, when I change the highlight color in one spreadsheet, it changes it in the second spreadsheet too. How can I keep these separate?
Highlighting cells. On one worksheet I'm highlighting the cells gray when the item is complete, and the other I'm highlighting yellow. When I select the highlight color on one worksheet window, it changes it on the other window as well. I have to change it every time I go to each worksheet. @Jan Karel Pieterse