Results 1 to 7 of 7

How to make conditional formatting permanent

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-06-2021
    Location
    USA
    MS-Off Ver
    365
    Posts
    261

    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.

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. [SOLVED] 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. [SOLVED] 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