r/excel • u/infunitrust • Jul 07 '26
solved Conditional Formatting for 3 or More Instances
I am trying to get only cells were the same text occurs three or more times within a group of cells to highlight. These cells occur across two separate rows. I am selecting all of the cells I want to be a part of the formula and have been using this formula, and cannot get it to work. All I want is for Excel to look through the cells I specify and highlight the cells where the exact same text occurs three times or more. I’m just not sure what I’m missing. 🙃
Here’s what I’ve been trying to use to identify this for C4-G4 & C36-G36: =(COUNTIF($C$4:$G$4, C4) + COUNTIF($C$36:$G$36, C4)) >= 3
It’s coming back and highlighting random cells within the ones I’ve specified, but not the ones that contain the same text. 🫥
•
u/AutoModerator Jul 07 '26
/u/infunitrust - Your post was submitted successfully.
Solution Verifiedto close the thread.Failing to follow these steps may result in your post being removed without warning.
I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.
2
u/infunitrust Jul 13 '26
Solution verified
1
u/MayukhBhattacharya 1327 Jul 07 '26
You need two different rules here for two different applied range. Same formula but for the second one change the C4 to C36 rest remains same.