•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Highlight cell formula fir first 5 string
Can I put a highlight cell formula in without a helper column?
I'm looking for a simple solution that accomplishes the following.:
search column and highlight cell formula for
first 5 characters in table1col1 match the first 5 characters in table2 col2.
The records are out of order.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#AI formula generation techniques
#formula generator
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#Excel compatibility
#Excel alternatives
#highlight cell formula
#helper column
#first 5 characters
#search column
#table1col1
#table2 col2
#records out of order
#simple solution
#match
#Excel
#string
#formula