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?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Highlighting every 6th occurence in a table - conditional formatting?
etaf
Well-known Member
- Joined
- Oct 24, 2012
- Messages
- 8,789
- 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
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
Upvote
0
Similar threads
- Question
- Question
