I'm using Excel 2013 and I have a column with 30,000 items. Below is sample format of items , now using Conditional Formatting I wanted to highlight only consecutive columns where count > 2. I tried Conditional Formatting->Highlight Cells Rules ->Duplicate Values. It highlights all occurrences.
I Only want to highlight consecutive duplicate columns? .
Current requirement is not to use any additional columns but use existing column only.
ITEM 1
ITEM 2
ITEM 3
ITEM 3
ITEM 4
ITEM 5
ITEM 3
ITEM 2
ITEM 4
ITEM 4