+ Reply to Thread
Results 1 to 4 of 4

Multiple Conditional Formatting Rules

  1. #1
    Registered User
    Join Date
    07-20-2018
    Location
    PA
    MS-Off Ver
    Office 365
    Posts
    2

    Question Multiple Conditional Formatting Rules

    I am trying to set up multiple conditional formatting rules so that if any checkbox for Tested, Plan or Script for Part A is checked then Part A cell will turn Red. If two of the Tested, Plan or Script checkboxes are checked then Part A cell will turn Yellow and if all 3 checkboxes are checked then Part A cell will turn Green.

    I have the following rules created in Conditional Formatting but I can only get the Part A cell to turn Red. The Yellow and Green rules don't seem to work. Any help would be greatly appreciated! Thank you!

    RED =IF(COUNTIF($B$4:$D$4,TRUE),TRUE,FALSE)
    YELLOW =IF(OR(COUNTIF($B$4:$D$4,TRUE),COUNTIF($B$4:$D$4,TRUE)),TRUE,FALSE)
    GREEN =IF(OR(COUNTIF($B$4:$D$4,TRUE),COUNTIF($B$4:$D$4,TRUE)),TRUE,FALSE)

    Example.JPG

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Multiple Conditional Formatting Rules

    Hi and welcome.

    Try formulas like this:
    Red:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Amber:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Green:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    See attached.

    BSB
    Attached Files Attached Files
    Last edited by BadlySpelledBuoy; 07-20-2018 at 07:59 AM.

  3. #3
    Registered User
    Join Date
    07-20-2018
    Location
    PA
    MS-Off Ver
    Office 365
    Posts
    2

    Re: Multiple Conditional Formatting Rules

    WOW! Awesome! That worked perfectly! Thank you SO much and thank you for the quick reply as well!

  4. #4
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Multiple Conditional Formatting Rules

    Happy to help

    BSB

+ 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] Using if and And together in conditional formatting multiple rules!
    By Katieloulouise in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 02-03-2015, 01:00 PM
  2. Replies: 6
    Last Post: 06-21-2014, 08:39 PM
  3. Conditional Formatting, multiple rules
    By jsch08 in forum Excel General
    Replies: 1
    Last Post: 04-30-2013, 11:30 PM
  4. Conditional Formatting with multiple rules
    By carrod65 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-24-2012, 03:43 PM
  5. Conditional Formatting with multiple rules
    By Peter Richardson in forum Excel General
    Replies: 6
    Last Post: 07-07-2011, 02:08 AM
  6. Conditional formatting multiple rules
    By candrew03 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-16-2011, 02:35 PM
  7. Conditional Formatting Multiple Rules
    By ems.payroll in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-07-2008, 12:31 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