Conditional format against column value of pivot table

Hello all

I'm a bit stuck

I have created a pivot table with row as transaction ID, column as collection bought into and value as demand

I have a list of over 33,000 rows, what i need to apply is a formula which tells me whether the transactor bought into more than one collection

Any help welcome, i have attached an example of expected output

Thanks in advance

Here's a formula that will show Yes or No like in your sample.

Try this in F4:

=IF(COUNT(B4:E4)>1,"Yes","No")

Drag the formula down column F.