Results 1 to 3 of 3

Thread: Conditional formatting that ignores other rules

  1. #1

    Question Conditional formatting that ignores other rules



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I'm working on a spreadsheet with a large list of schools, and color coding them based upon the grades they serve. Currently, the conditional formatting rules use the name of the school ("Elementary" in the name is colored green," Middle School or Jr High is colored red, etc.). However, there are some schools with the name Elementary in it that actually serve grades Kindergarden through 8th grade, while the definition of elementary that I have been using is generally Kindergarden through 5th grade.

    I want to color code these K-8 schools blue, and can do so manually, but only if the school name does not have "elementary" or "grade school" in it. Is there a formula that both pays attention to a "Grades Served" field that is in the spreadsheet and overrides the "contains Elementary" or "contains grade school" name rule?

    Let me know if I need to provide any more information. Thanks!

  2. #2
    Good afternoon,

    Use something like:

    If ( and ( Name = "elementary" , Grades Served <> "K-5" ) , 1 , 0 )

    You can set this as the highest priority in the conditional formatting queue.

    Hope this helps,

  3. #3
    Quote Originally Posted by bgoree09 View Post
    Good afternoon,

    Use something like:

    If ( and ( Name = "elementary" , Grades Served <> "K-5" ) , 1 , 0 )

    You can set this as the highest priority in the conditional formatting queue.

    Hope this helps,
    You don't need the IF in CF

    =AND(Name="elementary",Grades Served<>"K-5" )

    will suffice

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •