+ Reply to Thread
Results 1 to 2 of 2

Conditional Formatting two rules

  1. #1
    Valued Forum Contributor
    Join Date
    04-21-2005
    Location
    Southern England
    MS-Off Ver
    Excel for Office 365
    Posts
    1,689

    Conditional Formatting two rules

    Hi,

    Currently I have conditional formatting, very simply the formula is: =L9=TRUE

    Now I need to add the condition If D9 = "A" also within the same formula. How do I do that?

    What I have is three difference conditions A/B/C and I need to colour based on the conditions. e.g. A = Blue, B = Yellow and C = Green
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    08-04-2011
    Location
    UK
    MS-Off Ver
    Excel 2021
    Posts
    346

    Re: Conditional Formatting two rules

    for the blue, =AND(L9=TRUE,D9="A")
    similar for the others
    Last edited by AlanY; 11-21-2014 at 11:17 AM.

+ 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 rules
    By puzzlelover22 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-01-2014, 12:45 PM
  2. 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
  3. 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
  4. Conditional Formatting with rules
    By howcroc in forum Excel General
    Replies: 6
    Last Post: 02-04-2011, 12:01 PM
  5. Conditional Formatting with more than 3 rules
    By vickyho1008 in forum Excel General
    Replies: 5
    Last Post: 07-24-2008, 10:06 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