+ Reply to Thread
Results 1 to 3 of 3

Conditional formatting, 3 different rules for 3 different colors

  1. #1
    Registered User
    Join Date
    02-23-2017
    Location
    Seattle
    MS-Off Ver
    Mac 15
    Posts
    24

    Conditional formatting, 3 different rules for 3 different colors

    Hi.
    I have a list of names that I either want the column colored red, green, or yellow. Right now I have two differnet rules, one for red, and one for yellow.

    so for instance yellow is =AND(B1="ABC",C1<2) and red is =AND(B1="ABC",C1>2). I will add a third for green, but my question is what is the most clean and efficient way to do this? Can this be in one giant conditional format rule or do I need to make three different ones?

    TY!

  2. #2
    Valued Forum Contributor spitfireblue's Avatar
    Join Date
    01-29-2015
    Location
    Adelaide, Australia
    MS-Off Ver
    2007,2010,2016
    Posts
    611

    Re: Conditional formatting, 3 different rules for 3 different colors

    You need to make 3 different ones.
    Regards,
    Stephen

    If you feel someone has helped you please thank them and click on the star on their post to add reputation.
    Please ensure that you use code tags where relevant, and mark solved threads as solved.
    Most of all please be respectful and understanding of others.

  3. #3
    Registered User
    Join Date
    02-23-2017
    Location
    Seattle
    MS-Off Ver
    Mac 15
    Posts
    24

    Re: Conditional formatting, 3 different rules for 3 different colors

    Thank you.

+ 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 with more than 15 rules
    By lnjkbsn in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 04-26-2016, 05:01 AM
  2. [SOLVED] Conditional Formatting - 2 rules in 1
    By Leathermyth in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-19-2015, 02:29 PM
  3. Conditional Formatting two rules
    By pauldaddyadams in forum Excel General
    Replies: 1
    Last Post: 11-21-2014, 11:15 AM
  4. [SOLVED] 2 rules for conditional formatting
    By alfgrey in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 09-04-2013, 10:57 AM
  5. conditional formatting rules for a cell on sheet 1 based on rules from sheet 2
    By jsard in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 08-15-2013, 09:22 AM
  6. What new rules do I need for Conditional Formatting?
    By ypurcaro in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-12-2013, 04:30 AM
  7. [SOLVED] Conditional Formatting Rules Help
    By PCAg in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-11-2012, 05:33 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