+ Reply to Thread
Results 1 to 4 of 4

Conditional formatting: apply changes permanently

  1. #1
    Registered User
    Join Date
    06-14-2012
    Location
    Geneva, Switzerland
    MS-Off Ver
    Excel 2011 mac
    Posts
    2

    Conditional formatting: apply changes permanently

    Hi,

    I noticed my conditional formatting looks different in another computer. Is there a way to apply the conditional change permanently, ie to change the conditional formatting into cell parameters like background and text colors?

    Best,

    Yvan

  2. #2
    Valued Forum Contributor
    Join Date
    04-30-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    547

    Re: Conditional formatting: apply changes permanently

    How does the CF look different in another computer? Can you supply details, like screenshots? CF applies formats based on conditions. If the condition is met, the format is applied. If thing differ between computers, it would be worth checking the setup.
    Like a post? Click the star below it!

  3. #3
    Registered User
    Join Date
    06-14-2012
    Location
    Geneva, Switzerland
    MS-Off Ver
    Excel 2011 mac
    Posts
    2

    Re: Conditional formatting: apply changes permanently

    Hello,

    Actually, the CF is interpreted correctly. I my case, I change the colors of cells depending on the number they contain (eg: green if > 100). For example I chose that in this case, the background is light blue. For some reason, the background appears as DARK blue on the other computer.

    Yvan

  4. #4
    Valued Forum Contributor
    Join Date
    04-30-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    547

    Re: Conditional formatting: apply changes permanently

    What are the Excel versions involved in the scenario? Are there any custom color schemes/themes in the mix?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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