Working in multiple spreadsheets - highlighting (Excel 2013)

%3CLINGO-SUB%20id%3D%22lingo-sub-905762%22%20slang%3D%22en-US%22%3EWorking%20in%20multiple%20spreadsheets%20-%20highlighting%20(Excel%202013)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-905762%22%20slang%3D%22en-US%22%3E%3CP%3EI%20frequently%20work%20in%20two%20spreadsheets%20simultaneously.%26nbsp%3B%20I%20highlight%20in%20both.%26nbsp%3B%20My%20problem%20is%20now%20that%20we're%20using%20Excel%202013%2C%20when%20I%20change%20the%20highlight%20color%20in%20one%20spreadsheet%2C%20it%20changes%20it%20in%20the%20second%20spreadsheet%20too.%26nbsp%3B%20How%20can%20I%20keep%20these%20separate%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-905762%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETips%20and%20Tricks%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-908663%22%20slang%3D%22en-US%22%3ERe%3A%20Working%20in%20multiple%20spreadsheets%20-%20highlighting%20(Excel%202013)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-908663%22%20slang%3D%22en-US%22%3EWhat%20do%20you%20mean%20by%20highlight%20color%3F%20Can%20you%20show%20us%20a%20screenshot%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-908714%22%20slang%3D%22en-US%22%3ERe%3A%20Working%20in%20multiple%20spreadsheets%20-%20highlighting%20(Excel%202013)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-908714%22%20slang%3D%22en-US%22%3E%3CP%3EHighlighting%20cells.%26nbsp%3B%20On%20one%20worksheet%20I'm%20highlighting%20the%20cells%20gray%20when%20the%20item%20is%20complete%2C%20and%20the%20other%20I'm%20highlighting%20yellow.%26nbsp%3B%20When%20I%20select%20the%20highlight%20color%20on%20one%20worksheet%20window%2C%20it%20changes%20it%20on%20the%20other%20window%20as%20well.%26nbsp%3B%20I%20have%20to%20change%20it%20every%20time%20I%20go%20to%20each%20worksheet.%26nbsp%3B%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-908972%22%20slang%3D%22en-US%22%3ERe%3A%20Working%20in%20multiple%20spreadsheets%20-%20highlighting%20(Excel%202013)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-908972%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F423806%22%20target%3D%22_blank%22%3E%40terlynn_1370%3C%2FA%3E%20Are%20you%20by%20any%20chance%20referring%20to%20this%20button%20(the%20one%20with%20the%20red%20box%20around%20it)%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20394px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F137186i8EBDCB2D353D752D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%222019-10-11_17-00-41.gif%22%20title%3D%222019-10-11_17-00-41.gif%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EIf%20yes%2C%20then%20the%20only%20way%20to%20achieve%20what%20you%20need%20is%20by%20launching%20a%20second%20instance%20of%20Excel.%20In%20Windows%20Excel%20you%20do%20so%20by%20holding%20down%20the%20Alt%20key%20while%20starting%20Excel.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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?

3 Replies
Highlighted
What do you mean by highlight color? Can you show us a screenshot?
Highlighted

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 

Highlighted

@terlynn_1370 Are you by any chance referring to this button (the one with the red box around it):

 2019-10-11_17-00-41.gif

If yes, then the only way to achieve what you need is by launching a second instance of Excel. In Windows Excel you do so by holding down the Alt key while starting Excel.