Multiple or single entries for one value

Hi, welcome to the forum

My purpose is to distinguish value C,

and do what?

Do you want the cells column B to change color, or to have a another column that shows the difference? What about if some in B match, like the others?

Hi, welcome to the forum

My purpose is to distinguish value C,

and do what?

Do you want the cells column B to change color, or to have a another column that shows the difference? What about if some in B match, like the ithers?

with a pivot table and a helpcolumn

the result is in the green cells.

Try this...

Data Range

	A	B
1	A	1
2	A	1
3	A	1
4	B	5
5	C	7
6	C	3
7	C	2
8	------	------

Select the ENTIRE range A1:B7 starting from cell A1.
Cell A1 will be the active cell. The active cell is the
one cell in the selected range that is not shaded. The
formula will be relative to the active cell.

Goto the Home tab>Styles>Conditional Formatting>
Manage rules>New rule>Use a formula to determine
which cells to format

Enter this formula in the box below:

=COUNTIFS($A:$A,$A1,$B:$B,$B1)<>COUNTIF($A:$A,$A1)

Click the Format button
Select the desired style(s)
OK out