Hello,
I have two different Excel documents open at the same time in two separate Excel windows (using Excel in Microsoft 365 Enterprise).
I basically have to compare the two documents side by side, and set the font color on one document to be one color (red) for certain items, and a different color (green) on the other document.
Currently, when I change the font color selector on one document, it changes in the second Excel instance as well. This means that every time I go back and forth from left to right, I have to manually switch the color back every single time. I know it's only one extra click, but I have to repeat this many many times each day, every day.
What I would like is for each instance of Excel to be able to remember the font color I've selected for it, so that when I set one window to red and the other to yellow, they both stay the way I set them in that instance. That way I can just click the cell and then the color each time, without having to go through the dropdown color selector as well.
Is this possible?
Thanks for any ideas.
Bookmarks