Formula to highlight individual occurence

[thelad]

Hi,

Dos anyone know a formula to use in conditional formatting to highlight occurrence of values.

         1  3  3  3  4  4  1

So for example 1, 3 and 4 would be highlighted. So Basically just one occurrence of each cell.

Regards,

 

[Oscar Cronquist]

Excel 2016 (Windows) 32 bit
[Table="width:, class:head"][tr=bgcolor:#E0E0F0][th] [/th][th]

A​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

1​

[/td][td=bgcolor:#FFC000]

1​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

2​

[/td][td=bgcolor:#FFC000]

3​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

3​

[/td][td]

3​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

4​

[/td][td]

3​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

5​

[/td][td=bgcolor:#FFC000]

4​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

6​

[/td][td]

4​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

7​

[/td][td]

1​

[/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Sheet35[/td][/tr][/table]

CF formula:
=COUNTIF($A$1:A1,A1)=1

 

[thelad]

Hi,

Not sure tat worked. or example m datais in row 18 and going across numerous columns. I would like to highlight each occurance of particular name etc.

so for example what you have highlighted above Is correct but I can't seem to get it to work?

Regards

 

[thelad]

hi got it working - Thanks