Forum Discussion
Formula of 2 numbers are the same...
Looking for help on creating a formula that if there are two "1"s it either changes the color or replaces the average cell to 1. Example: 3 5 1 1 Average:2.5 (there are two "1" can this change c...
You may use the conditional formatting.
Under conditional formatting, choose use formula and type in
= countif(A1:A4,1) > 1
and then choose the colour / formatting you want.