Results 1 to 5 of 5

AND is not working with conditional formatting

Threaded View

PDX_Rugger8 AND is not working with... 02-18-2015, 02:20 PM
XOR LX Re: AND is not working with... 02-18-2015, 02:41 PM
Pete_UK Re: AND is not working with... 02-18-2015, 02:42 PM
ChemistB Re: AND is not working with... 02-18-2015, 02:51 PM
PDX_Rugger8 Re: AND is not working with... 02-18-2015, 02:55 PM
  1. #1
    Registered User
    Join Date
    02-18-2015
    Location
    Portland, OR
    MS-Off Ver
    Office 2013
    Posts
    2

    AND is not working with conditional formatting

    Hello All,

    I am trying to do some conditional formatting based on multiple conditions. I need to quickly see if students are on level based on their grade level and placement score. However their "placement" is also conditional to their grade level. i.e. if a 1st and 2nd grader get the same score on the placement test they will be placed at different levels. The formula I have been using is =IF(AND($E3=1,$H3>=$N$4),"1Green"). Where Column E is their grade level, Column H is their score on the test, and N4 is the minimum cut off for placement in their current grade (I chose not to put an actual number for for N4 because the cut off scores may change in the future) I know this formula works in the actual sheet because I have tested it on cells matching the criteria (it returns 1Green for true and false for false). However, when I put it in conditional formatting it doesn't work. I have tried to modify it in many different ways to make it work, but I am just not savvy enough. Can someone help me, please?

    I have attached a worksheet. It looks a bit weird because I have removed the identifying information for the students, but kept the formulas intact. The table on the right is the range of cut off scores (grade"x" is their grade level when taking the test and the Level"x" is their placement based on their score) There are some blanks where students have not taken the test, I would like those to stay blank. As you will see I have separate formulas for 1st through 12th grade and whether they are on grade or above (green), one level below(yellow) or two or more levels below(red). Eventually I will need all of these to go into conditional formatting, but if I can figure out why it won't work on the previously specified formula, I can apply it to the rest of them myself. I am sure it's something simple I'm not seeing. Thanks in advance for any help!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Conditional formatting not working
    By Marcel Coetzee in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-07-2014, 05:35 PM
  2. Conditional formatting not working
    By michmat120 in forum Excel General
    Replies: 3
    Last Post: 12-13-2013, 04:16 PM
  3. Conditional Formatting is not working
    By rengrish in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-04-2012, 01:23 AM
  4. Conditional Formatting not Working
    By braydon16 in forum Excel General
    Replies: 7
    Last Post: 05-23-2012, 02:41 PM
  5. VBA conditional formatting not working
    By LarryC in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-26-2008, 09:43 AM

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