•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.
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]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#Excel alternatives for data analysis
#Excel compatibility
#row zero
#natural language processing for spreadsheets
#generative AI for data analysis
#conditional formatting
#highlight
#value
#pink
#orange
#instance
#row
#format
#appear
#times
#Excel
#chart
#subsequent
#highlighted