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 ...
=AND(H1:H8998="maximum", L1:L8998>=30,P1:P8998="Level")
This did not work. What have I done wrong?
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")