+ Reply to Thread
Results 1 to 3 of 3

Two different font colors in two separate workbooks at the same time?

  1. #1
    Registered User
    Join Date
    11-03-2013
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2010
    Posts
    21

    Question Two different font colors in two separate workbooks at the same time?

    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.

  2. #2
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    3,060

    Re: Two different font colors in two separate workbooks at the same time?

    Why not select same color for both documents, then after completion, use Ctrl+F to find the cells with the color and change the color then.

  3. #3
    Registered User
    Join Date
    11-03-2013
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2010
    Posts
    21

    Re: Two different font colors in two separate workbooks at the same time?

    Thanks for the suggestion, but the process uses more than one color and triple-cross-checks with a printed document while I'm comparing the two files. There are also a lot of other colors on the sheet, but one sheet is the previous version of the newer one, so basically I change the new document to match the older one, and then change the older one to show which items have matched. I'm only doing this for my immediate visual feedback though, so keeping them the same color just doesn't work in this particular situation. I was just hoping for a way to basically click one color on one screen, and another on the other screen, but Excel seems to want to match them on both instances. Curiously enough, it doesn't do this with the cell-fill color and actually does let me use a different color per instance (which is why I was hoping there was a way to do this with the font color as well). Thanks again for the suggestion.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 02-27-2018, 12:59 AM
  2. Missing Font colors ??
    By roehrle in forum Excel General
    Replies: 16
    Last Post: 04-12-2016, 02:55 AM
  3. Different font colors - same checkbox
    By twckfa16 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-02-2015, 10:44 PM
  4. Font colors different in 2007
    By SeanDamnit in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-16-2013, 08:47 PM
  5. Replies: 1
    Last Post: 11-19-2012, 12:04 PM
  6. Font colors
    By RoyR in forum Excel General
    Replies: 2
    Last Post: 10-19-2005, 08:05 PM
  7. Can't format font colors or cell fill-in colors
    By canoeron in forum Excel General
    Replies: 3
    Last Post: 08-22-2005, 07:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1