+ Reply to Thread
Results 1 to 5 of 5

Nested Color Conditional Formating

  1. #1
    Registered User
    Join Date
    01-25-2018
    Location
    Crook, Colorado
    MS-Off Ver
    2013
    Posts
    2

    Nested Color Conditional Formating

    Okay,
    We have cut points that students are expected to meet with their testing.

    I am trying to make it so that IF the student is in grade 0 (Column B) and any of their scores are below 150 (Columns c-f), mark that cell with the low score yellow.
    If the student is in grade 1 (column B) and any of their score are below a 172, mark that yellow.

    Can't wrap my brain around it!
    Attached Files Attached Files

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Cool Re: Nested Color Conditional Formating

    are you sure both colors should be yellow?

    try this but if you want both yellow change blue to yellow

    =AND($B3=0,C3<150)
    =AND($B3=1,C3<172)

    both for range: =$C$3:$F$38
    Attached Files Attached Files

  3. #3
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: Nested Color Conditional Formating

    Does this work?

    =AND(B$3:B$1000=0,COUNTIF(C$3:F$1000,"<150"))
    format as yellow

    =AND(B$3:B$1000=1,COUNTIF(C$3:F$1000,"<172"))
    format as yellow
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  4. #4
    Registered User
    Join Date
    01-25-2018
    Location
    Crook, Colorado
    MS-Off Ver
    2013
    Posts
    2

    Re: Nested Color Conditional Formating

    That is perfect. Thank you!

  5. #5
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Nested Color Conditional Formating

    which one?

    use @[screen name] if you talking to someone

+ 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] 3 color scale conditional formating help
    By Excel15 in forum Excel General
    Replies: 2
    Last Post: 07-12-2017, 12:40 PM
  2. Random color conditional formating
    By j_analyst in forum Excel General
    Replies: 7
    Last Post: 11-26-2016, 02:13 PM
  3. [SOLVED] Wasn't able to color the whole row with Conditional Formating
    By hellforce in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-13-2014, 07:31 AM
  4. [SOLVED] Trouble with Two conditional formating IFcell>0=color or IF cell blanck=color
    By Jeff up North in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-07-2013, 08:12 PM
  5. [SOLVED] Conditional formating and worksheet tab color
    By dwhite30518 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-24-2012, 10:09 AM
  6. [SOLVED] VBA for conditional formating and color sorting
    By juskojj in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 04-11-2012, 02:49 PM
  7. Conditional Formating - Change Color
    By hfazal in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-15-2006, 02:45 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