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 color or replace total to 1?)
Hope that explains it, any help is very much appreciative.
Example:
3
5
1
1
Average:2.5 (there are two "1" can this change color or replace total to 1?)
Hope that explains it, any help is very much appreciative.
1 Reply
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.
