Highlight every 5th recurrence in a column for a given value/id

S

Shivesh

Joined
Oct 13, 2015
Messages
1
Reaction score
0
HI,

Can anyone help me finding a formula to Highlight every 5th recurrence in a column for a given value/id? Basically I have a value and I want to highlight when it occurs 5th time in a sorted column.

Thanks
 
XLPadawan

XLPadawan

Joined
Jun 9, 2016
Messages
32
Reaction score
5
This will work no matter whether your data is or isn't sorted.

NOTE: Conditional Formatting rule screenshots are at the end of this post.​

Here's the formula to copy and modify for your worksheet:
=IF((COUNTIF($I23:I$24,I23))=5,TRUE,"")​

upload_2016-6-14_11-13-42.png


upload_2016-6-14_11-20-58.png

upload_2016-6-14_11-19-47.png
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
Indenting every other paragraph in Word at the same time? 0
Need Help with a VBA subroutine 0
VBA Coding Help for Beginner 0
Calculate the median value before a specified list 0
Extracting a cell value 2
REINSTALLING MS OFFICE PRO PLUS 2019 0
MS Project Center-Autolink column fields 0

Top