conditional formating

[ericlch16]

I use this in conditional formatting

=COUNTIF(E:E,Fx) turns green colour x can be 1,2,3

now what if
f1= AAA
F2 = CCC
f3 = BBB

in E:E there are two times "CCC"

column E:
CCC
AAA
BBB
CCC


It should not turn green.. only turns green if there is only one match.. if there are more than one match do not turn green

f1 =>colour green
F2 => do not turn green
f3 => colour green

 

[T. Valko]

I use this in conditional formatting

=COUNTIF(E:E,Fx) turns green colour x can be 1,2,3

now what if
f1= AAA
F2 = CCC
f3 = BBB

in E:E there are two times "CCC"

column E:
CCC
AAA
BBB
CCC


It should not turn green.. only turns green if there is only one match.. if there are more than one match do not turn green

f1 =>colour green
F2 => do not turn green
f3 => colour green

Try this...

=COUNTIF(E:E,Fx)=1