+ Reply to Thread
Results 1 to 7 of 7

How to make conditional formatting permanent

  1. #1
    Forum Contributor
    Join Date
    07-06-2021
    Location
    Idaho
    MS-Off Ver
    2016
    Posts
    171

    How to make conditional formatting permanent

    Hello, so in this example I need...
    0/blank to show a red "X"
    1 to show a yellow "!"
    2 or more to show a green "check mark"
    And all that next to the names, not in the duration row or the sub rows under the names.

    Attached I included a mock table with the expectations. I attempted to highlight the irrelevant rows and clear the conditional formatting, but it didn't stick.

    When I tried to do it I ran into the following issues
    1. It was labor intensive and I was hoping there is an easier way.
    2. Whenever I collapsed or expanded the list the conditional formatting went away for good.
    3. I couldn't get the red "X" to show for the 0/Blank values.
    Attached Files Attached Files
    Last edited by kyber; 12-14-2021 at 10:27 AM.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    34,780

    Re: How to make conditional formatting permanent

    Conditional Formatting does what it says on the tin. It changes formatting depending on one or more conditions. What it can't do is change or add content to cells. And it isn't permanent; it depends on the conditions. The conditions change, so does the formatting.
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Contributor
    Join Date
    07-06-2021
    Location
    Idaho
    MS-Off Ver
    2016
    Posts
    171

    Re: How to make conditional formatting permanent

    Bummer, thank you.

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    34,780

    Re: How to make conditional formatting permanent

    You're welcome.

  5. #5
    Forum Contributor
    Join Date
    07-06-2021
    Location
    Idaho
    MS-Off Ver
    2016
    Posts
    171

    Re: How to make conditional formatting permanent

    I got it to work. Can someone delete this please.

  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    34,780

    Re: How to make conditional formatting permanent

    You can't delete posts, or the thread. However, if you have a solution, why not share it for the benefit of others.

  7. #7
    Forum Contributor
    Join Date
    07-06-2021
    Location
    Idaho
    MS-Off Ver
    2016
    Posts
    171

    Re: How to make conditional formatting permanent

    Collapse all fields, highlight them to the applicable cells and then do the conditional formatting as opposed to applying the entire table.

+ 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. [SOLVED] Permanent Conditional Formatting for Table
    By JBlo in forum Excel General
    Replies: 4
    Last Post: 04-07-2014, 03:38 PM
  2. Emulating conditional formatting in VBA, but making it permanent.
    By lankyfish in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-19-2013, 12:36 PM
  3. Permanent Conditional Formatting Setting
    By gaspower in forum Excel General
    Replies: 2
    Last Post: 11-14-2012, 01:18 AM
  4. Remove the date from a date time field / make formatting permanent
    By Ariadust in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-10-2012, 04:15 PM
  5. How do I make gridlines permanent?
    By namrok29 in forum Excel General
    Replies: 3
    Last Post: 04-26-2011, 08:32 PM
  6. Make conditional formatting permanent
    By nsv in forum Excel General
    Replies: 0
    Last Post: 10-07-2008, 11:25 AM
  7. make custom formatting permanent
    By simha in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-15-2005, 07:35 PM

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