+ Reply to Thread
Results 1 to 3 of 3

Conditional Formatting Multiple Criteria

  1. #1
    Registered User
    Join Date
    02-14-2017
    Location
    Philippines
    MS-Off Ver
    2010
    Posts
    19

    Conditional Formatting Multiple Criteria

    Is it possible to create a conditional formatting based on multiple cell conditions?
    Attached is my sample data.Dummy Data.JPG


    What want to do is to color code the cell based on the skill level.
    Like in this case skill level 5 would be dark green. 3 would be light green, etc.

  2. #2
    Registered User
    Join Date
    05-02-2017
    Location
    Cochin
    MS-Off Ver
    2013
    Posts
    35

    Re: Conditional Formatting Multiple Criteria

    Hello ibo0389,

    You can do the conditional formatting for the above said Caterina using the option called "Use a formula to determine which cells to format" under "New formatting rule" of Conditional Formatting.

    Imagine your skill level scores starts from Cell B2.Then apply the below formulas in "Use a formula to determine which cells to format" field.

    Conditional Formatting.JPG

    Hope it fulfills your requirement.

  3. #3
    Registered User
    Join Date
    02-14-2017
    Location
    Philippines
    MS-Off Ver
    2010
    Posts
    19

    Re: Conditional Formatting Multiple Criteria

    Thanks a lot!

+ 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 - Multiple Criteria
    By zobrien in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 05-24-2017, 12:29 PM
  2. [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
  3. [SOLVED] conditional formatting for multiple criteria
    By tom72517 in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 10-08-2013, 08:01 PM
  4. [SOLVED] Conditional formatting - multiple criteria
    By bobbie_ch in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-05-2013, 08:46 AM
  5. [SOLVED] How do I use Conditional Formatting with multiple criteria?
    By Rhoran in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-28-2013, 01:56 AM
  6. Replies: 5
    Last Post: 12-28-2012, 02:06 PM
  7. 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