Forum Discussion
Solved
Excel Formula
Hi, I would like to ask if there’s a formula to highlight every nth time a specific value pops up. for example;
apple, orange, apple, banana, strawberry, apple
when every third ‘apple’ shows up it will highlight the cell.
apple, orange, apple, banana, strawberry, apple
when every third ‘apple’ shows up it will highlight the cell.
Do you mean something like this?
If so you may apply conditional formatting rule to the range with formula as
=(COUNTIF($A1:A1,A1)>=3)*(A1<>"")
4 Replies
- another example would be;
apple banana apple banana apple banana orange orange orange
for the third banana, apple and orange it will automatically highlight the cell. meaning, instead of one exact value it is multiple values in one column. i dont know if my explanation is clear enough but i hope you understandDo you mean something like this?
If so you may apply conditional formatting rule to the range with formula as
=(COUNTIF($A1:A1,A1)>=3)*(A1<>"")- yes thank you so much this is what i meant, but is it okay if you could post a tutorial or something because im kinda beginner with this stuff and my situation is affection columns if that will change anything. thank you once again!
