Highlight or Return Item that has values in more than one column

[samvince]

Hi

I'm trying to figure out how to return or highlight an item, in this case an ASIN if the ASIN has a price in more than once column.

In my data each ASIN can potentially have a different price in each month which is in columns E(September), G(August), I(July), K(June).

I'd like to highlight or return an ASIN (column B) if it has more than one price. If it has only 1 price in 1 of the columns then that is fine.

Thanks

[BanginMyHeadOnMyDesk]

Using the below formula in a Conditional Formatting rule will highlight the instances with multiple values.
=COUNT(E2,G2,I2,K2)>1

See attached.

Beth.

[Fluff13]

Select B2:B228 & in conditional formatting, use this formula
=COUNT($E2,$G2,$I2,$K2)>1