Forum Discussion
Conditional formatting
Hello everybody and thank you that you are here to help! I need to make conditional formatting with three different colors to a single cell, but the rules for the three colors are not understandable...
For the GREEN rule it could be
=($A1=1)*( ($C1=1)+($C1=2)+($C1=3)+($C1=4)+($C1=5) ) + ($A1=2)*( ($C1=2)+($C1=4)+($C1=6)+($C1=8) ) + ($A1=3)*($C1=9)and similar for other rules