•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to highlight the same words in different rows quickly?
Hi excel crowd! How would I highlight the same words if they are always in a different row? In one report, apple might be in row 86 and banana in row 24. In another report, apple is in row 93 and banana in row 12. Always the same column though. In reality, I have ~100 different fruits, and I want to highlight 20 of them, but that's the idea. Same fruit names. Same column. Just different rows. How can I highlight all the fruit names quickly? Without doing it manually? I imagine it will be something like, "If you see "apple", "banana", then highlight yellow."?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#row zero
#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#highlight
#excel
#fruits
#rows
#column
#apple
#banana
#report
#same words
#highlight yellow
#manual
#names
#same fruit
#highlighting
#different