+ Reply to Thread
Results 1 to 5 of 5

How to modify conditional formatting to ignore specific values

  1. 12-13-2015, 04:17 AM #1
    GIS2013
    GIS2013 is offline
    Forum Contributor
    Join Date
    12-30-2012
    Location
    Israel
    MS-Off Ver
    2007, 2016
    Posts
    642

    How to modify conditional formatting to ignore specific values

    Hi,

    I'm trying to figure out how to apply conditional formatting while ignoring specific values.

    All is explained in the attached file.

    Thanks
    Attached Files Attached Files
    Please * if you like the answer
    Reply With QuoteRegister To Reply
  2. 12-13-2015, 04:28 AM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2405 (Windows 11 23H2 64-bit)
    Posts
    81,397

    Re: How to modify conditional formatting to ignore specific values

    Just add an extra rule that formats cells containing NY to no fill and black text.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 12-13-2015, 04:46 AM #3
    GIS2013
    GIS2013 is offline
    Forum Contributor
    Join Date
    12-30-2012
    Location
    Israel
    MS-Off Ver
    2007, 2016
    Posts
    642

    Re: How to modify conditional formatting to ignore specific values

    Very well. I'll try and report later.
    Reply With QuoteRegister To Reply
  4. 12-13-2015, 05:23 AM #4
    GIS2013
    GIS2013 is offline
    Forum Contributor
    Join Date
    12-30-2012
    Location
    Israel
    MS-Off Ver
    2007, 2016
    Posts
    642

    Re: How to modify conditional formatting to ignore specific values

    @AliGW - thanks, it works for me.
    Reply With QuoteRegister To Reply
  5. 12-13-2015, 07:44 AM #5
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2405 (Windows 11 23H2 64-bit)
    Posts
    81,397

    Re: How to modify conditional formatting to ignore specific values

    You're welcome!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Conditional formatting for duplicate values within a specific number range 2010
    By Nunzio in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 07-20-2014, 04:00 PM
  2. [SOLVED] Highlight cells that used the specific values twice of more. CONDITIONAL FORMATTING
    By sunjam in forum Excel General
    Replies: 3
    Last Post: 02-26-2014, 12:10 AM
  3. Vba code - to ignore conditional formatting
    By jedemeyer1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-23-2013, 08:05 PM
  4. Ignore Duplicate Values In Conditional Formatting
    By mightyeskimo in forum Excel General
    Replies: 13
    Last Post: 09-18-2010, 01:28 PM
  5. Modify Conditional Formatting
    By jamie.c in forum Excel General
    Replies: 15
    Last Post: 07-24-2009, 04:45 AM
  6. Modify a conditional formatting macro
    By dcgrove in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-29-2009, 04:50 PM
  7. Conditional Formatting- on specific values
    By johnnywinter in forum Excel General
    Replies: 4
    Last Post: 02-12-2009, 10:48 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1