+ Reply to Thread
Results 1 to 6 of 6

Conditional Formatting on column based on multiple Text criteria

  1. #1
    Registered User
    Join Date
    10-09-2014
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    49

    Conditional Formatting on column based on multiple Text criteria

    Hi!

    Wondering the rule I can use that will format a cell yellow if it matches specific account codes.

    Eg. Column D list account codes
    Need to highlight those that match S3C00, DIV00, WAY00

    Tried to use Format only cells that contain but unsure how to add more than one criteria.

    Thanks,
    R
    Attached Images Attached Images

  2. #2
    Registered User
    Join Date
    10-09-2014
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    49

    Re: Conditional Formatting on column based on multiple Text criteria

    Managed to figure it out using a ref list

    =OR($D8='TOP 20'!$A$2:$B$22)

  3. #3
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,040

    Re: Conditional Formatting on column based on multiple Text criteria

    If it's just those three use

    =ISNUMBER(SEARCH(D8,"S3C00 DIV00 WAY00"))
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  4. #4
    Registered User
    Join Date
    10-09-2014
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    49

    Re: Conditional Formatting on column based on multiple Text criteria

    Thank you but I have 20 total.

    Now my issue is being able to filter by color with grouped rows. Doesn't seem to be working as it's opening all hidden row.

  5. #5
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,040

    Re: Conditional Formatting on column based on multiple Text criteria

    Create a list of the specific account codes (looks like you have done, your formula will work fine as well)

    Use

    =NOT(ISERR(VLOOKUP(D8,Sheet2!A$1:A$1000,1,0)))

    where Sheet2!A1:A1000 is your list

    Not sure about filtering

  6. #6
    Registered User
    Join Date
    10-09-2014
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    49

    Re: Conditional Formatting on column based on multiple Text criteria

    Appreciate the other work around.
    I think I may have actually figured out both LOL I can Sort but I can't filter.
    Thanks again.

+ 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. Conditional formatting based on multiple text criteria
    By tanyaslater in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-01-2014, 10:27 PM
  2. Replies: 5
    Last Post: 12-28-2012, 02:06 PM
  3. [SOLVED] Use Conditional Formatting based on multiple criteria
    By jdmet135 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-25-2012, 09:11 AM
  4. [SOLVED] How to use conditional formatting based on multiple criteria
    By Dena in forum Excel General
    Replies: 3
    Last Post: 10-15-2012, 04:57 PM
  5. Replies: 4
    Last Post: 01-20-2011, 01:31 PM
  6. Conditional formatting based on multiple criteria (needs to be in VBA)
    By Fidd$ in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 10-12-2009, 09:11 AM
  7. Conditional formatting based on multiple criteria
    By mainemojo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-09-2009, 09:33 PM
  8. Conditional Formatting based on multiple criteria
    By twlove@ontuet.com in forum Excel General
    Replies: 2
    Last Post: 08-03-2006, 04:45 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