Results 1 to 10 of 10

Conditional Formatting with Too Many Conditions

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-20-2008
    Location
    UK
    MS-Off Ver
    Office 365 For Mac Excel Version 16.88
    Posts
    143

    Conditional Formatting with Too Many Conditions

    I have a column (F) in which the rows could contain anything. I want to use conditional formatting to highlight the cells that DON'T contain certain specific text or that are blank. The problem is that their are around 40 specific texts I don't want it to highlight. The text I don't want to highlight are:

    Part1, Part2 etc....Part10
    Part 1, Part 2 etc.....Part 10
    Disc1, Disc2 etc.....Disc10
    Disc 1, Disc 2 etc....Disc 10

    I've been using the formula =AND($F4<>"PART1",AND($F4<>"PART2",AND($F4<>"PART3",AND($F4<>"PART4",AND($F4<>"PART5",AND($F4<>"PART6",AND($F4<>"PART7",AND($F4<>"PART8",AND($F4<>"PART9",AND($F4<>"PART10",NOT(ISBLANK($F4))))))))))))

    This works okay but not if there is a space between Part and the number and not at all for Disc but it won't let me add any further conditions (I'm using the Mac version of Excel if that makes a difference)

    The obvious solution would be to use a wild card Part* and Disc* but when I try that it highlights everything except blanks. I'm assuming when using <> not equal it then takes the text literally i.e. it's looking to see Part* or Disc*

    Is there a way around this?
    Attached Files Attached Files
    Last edited by peakoverload; 08-14-2024 at 08:30 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to use conditional formatting with the help IF conditions
    By Pawnar in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 08-30-2019, 05:55 PM
  2. Delete Conditional Formatting conditions but keep cell formatting
    By Devendra.dvm in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-03-2016, 04:07 AM
  3. Delete Conditional Formatting conditions but keep cell formatting - Excel 2010
    By tetreama in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-09-2012, 08:28 PM
  4. How to add more conditional formatting conditions than 3?
    By Smirgelius in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 03-22-2009, 03:59 AM
  5. Re: More than 3 Conditional Formatting Conditions
    By Adam in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-06-2006, 03:40 PM
  6. Conditional formatting wth more than 3 conditions
    By Sue in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  7. Replies: 2
    Last Post: 05-11-2005, 04:06 AM

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