Forum Discussion
Solved
Conditional formatting with multiple criteria and dropdown list
I am trying to get a conditional formatting formula to work in the attached scenario. The CF is not showing at all on any column. The 1st column has a data validation dropdown list. I have tri...
- =AND($A2="In Progress",OR(AND(C$1>=$B2,C$1<=$C2),AND(D$1>=$B2,D$1<=$C2),AND(E$1>=$B2,E$1<=$C2)))
Apply this rule for green and in the manager for cf in the field "applies to" enter: =$D$2:$G$4
=AND($A2="Complete",OR(AND(C$1>=$B2,C$1<=$C2),AND(D$1>=$B2,D$1<=$C2),AND(E$1>=$B2,E$1<=$C2)))
Apply this rule for red and in the manager for cf in the field "applies to" enter: =$D$2:$G$4
=AND($A2="In Progress",OR(AND(C$1>=$B2,C$1<=$C2),AND(D$1>=$B2,D$1<=$C2),AND(E$1>=$B2,E$1<=$C2)))
Apply this rule for green and in the manager for cf in the field "applies to" enter: =$D$2:$G$4
=AND($A2="Complete",OR(AND(C$1>=$B2,C$1<=$C2),AND(D$1>=$B2,D$1<=$C2),AND(E$1>=$B2,E$1<=$C2)))
Apply this rule for red and in the manager for cf in the field "applies to" enter: =$D$2:$G$4
Apply this rule for green and in the manager for cf in the field "applies to" enter: =$D$2:$G$4
=AND($A2="Complete",OR(AND(C$1>=$B2,C$1<=$C2),AND(D$1>=$B2,D$1<=$C2),AND(E$1>=$B2,E$1<=$C2)))
Apply this rule for red and in the manager for cf in the field "applies to" enter: =$D$2:$G$4
- Thanks. While the cell refs in this solution don't match the sheet, the use of and(or)and has put me on the right track and I have it working now.
