Forum Discussion
Need to highlight a cell if 3 conditions are correct
I need to highlight a cell if 3 certain factors are true. I have tried the IF(AND(A2:A80="max", B2:B80>=30, C2:C3="Level")) and it does not work. Can anyone help me. I know how to use excel but ...
1) You don't need IF here.
2) The formula =AND(A2:A80="max", B2:B80>=30, C2:C3="Level") will return TRUE if ALL of the cells A2:A80 equal "max" and ALL of the cells B2:B80 are greater than or equal to 30 and ALL of the cells C2:C3 equal "Level". Is that really what you intended?
- =AND(H1:H8998="maximum", L1:L8998>=30,P1:P8998="Level")
This did not work. What have I done wrong?Do you want to highlight a cell in row 1 if H1 ="maximum" and L1>=30 and P1="Level", and similar for row 2 etc.? If so, make sure that the active cell in the selection is in row 1 when you create the rule, and use the formula
=AND($H1="maximum",$L1>=30,$P1="Level")
- =AND($H1="maximum",$L1>=30,$P1="Level 1")
This did highlight some of the cells, but not the correct ones.
