•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Locating unique text within a column and highlighting each row where the text is found
Hi all,
It seems my Conditional Formatting game is weak here (or maybe I'm taking the wrong approach?).
Essentially, I'm looking at an individual column across thousands of rows for 15 unique pieces of text. In each instance that any of the 15 words appears in the column, I would like to highlight the entire row.
I thought the best way to approach this was to use =SUM(COUNTIF($AG2, {"Text1", "Text2", "Text3", ...}))>0 by way of Conditional Formatting. However, I am being met with:
You may not use reference operators (such as unions, intersections, and ranges), array constants, or the LAMBADA function for Conditional Formatting criteria
Does anyone have an alternative approach to this?
TIA!
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#row zero
#Excel compatibility
#financial modeling with spreadsheets
#Excel alternatives
#Conditional Formatting
#highlight
#unique text
#column
#rows
#COUNTIF
#thousands of rows
#reference operators
#array constants
#LAMBDA function
#criteria
#alternative approach