+ Reply to Thread
Results 1 to 2 of 2

Conditional Formatting - Multiple Criteria

  1. #1
    Registered User
    Join Date
    04-26-2017
    Location
    reading
    MS-Off Ver
    2010
    Posts
    11

    Conditional Formatting - Multiple Criteria

    I have a set of data which has three columns: Persons name, profile score, engagement score.

    Profile score contains a letter from a-d
    Engagement score cotains a number from 1-4

    I am trying to create formatting that highlights the persons name when the profile score is a,b or c AND their engagement score is 1,2 or 3. So in the end only those that are a1, a2, a3, b1, b2 , b3 are highlighted.

    Any suggestions?

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166
    Hello zobrien,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ 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] Conditional Formatting over multiple cells with multiple criteria validator
    By effendrew in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-31-2015, 05:05 PM
  2. [SOLVED] Conditional Formatting help (multiple criteria)
    By MzP in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-20-2015, 07:15 AM
  3. [SOLVED] Conditional Formatting with Multiple Criteria
    By swarnbr in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-06-2014, 03:34 PM
  4. Replies: 5
    Last Post: 12-28-2012, 02:06 PM
  5. Conditional formatting multiple criteria
    By imcurious in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 10-28-2011, 05:36 AM
  6. conditional formatting, multiple criteria
    By Lara in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-27-2006, 02:20 PM
  7. [SOLVED] conditional formatting, multiple criteria
    By Lara in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-27-2006, 01:45 PM

Tags for this Thread

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