I have a data list of around 32000 items in column A. Each of these items has many duplicates, some having 1 duplicate, up to about 5 or so max. Each cell has multiple sku's, divided by a /.
What I need to do is determine the count of /'s in a single cell, and if that count equals the amount of duplicates, color the cell green, if not, color the cell orange.
1001/1002/1003 1001/1002/1003 1001/1002/1003
All 3 of these cells would turn green, there are 2 slashes, and 2 duplicates of each cell (or 3 total cells duplicated)
Both of these would turn orange, as there are 2 slashes, and 3 entries. They would also be orange if there were 4 entries, or any number other than 3.
I can use formulas as necessary, and can even do this in multiple steps, such as an extra calculation cell that outputs yes or no, and I can color them myself by filtering etc.
I prefer to avoid VB in this as it is used by many users that have absolutely no clue how to use excel, but if necessary, I can use VB.