Highlighting every 6th occurence in a table - conditional formatting?

PIRC13

New Member
Joined
Jul 25, 2013
Messages
23
I have a spreadsheet of customers but need to select every 6th occurence of a particular product to audit these. Is conditional formatting a way of highlighting, not every 6th item in the table but every 6th occurence relating to a particular product when the table will contain a variety of cases/products?
 

Some videos you may like

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

etaf

Well-known Member
Joined
Oct 24, 2012
Messages
3,581
Office Version
365
Platform
MacOS
Re: Highlighting every 6th occurenct in a table - conditional formatting?

yes, and you maybe able to use a formula like
Assuming the product was in A column
countif($A$1:A1,A1) = 6
then it should highlight Just the sixth occurrence - But not the 12th or 18th
 

Watch MrExcel Video

Forum statistics

Threads
1,089,766
Messages
5,410,299
Members
403,309
Latest member
chaithra

This Week's Hot Topics

Top