J joesw Sep 25, 2009 #1 I would like to turn one cell several different colours according to the contents of other adjacent cells.
I would like to turn one cell several different colours according to the contents of other adjacent cells.
S Sean Timmons Sep 25, 2009 #2 =AND(B2=4,C2=6,etc) and set your color for each condition. Please keep in mind, if condition 1 is met, conditional formatting will NOT review any other conditions.
=AND(B2=4,C2=6,etc) and set your color for each condition. Please keep in mind, if condition 1 is met, conditional formatting will NOT review any other conditions.
