•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Creating a conditional format for the 3rd instance of a value highlighted pink, then every subsequent instance of that same value highlighted orange.
Our take
Are you struggling to highlight specific values in your spreadsheet while ensuring clarity? If you want to create a conditional format that highlights the third instance of a value in pink, while turning subsequent instances orange, you're in the right place. With the right formula, you can easily distinguish between these occurrences—like making "John" appear pink for the first three entries and orange for the fourth. Read on to discover a straightforward solution that will streamline your data visualization and enhance your spreadsheet’s effectiveness.
In column C I want a conditional format to highlight a value that appears 3 times to highlight the row in pink. I want to also have a conditional format that will highlight the 4th and subsequent instance of that value to be orange. What I have right now isn't working. In my chart "Adam" shows up three times and is pink. "John" shows up 4 times and is orange. I need John to show up pink up to the 3rd and then go orange on the 4th. So John would be pink in A2, A5 and A7 but then A10 would be orange.
Here is the conditional formatting I have right now.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience