1 min readfrom 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.

https://preview.redd.it/c6qr347ieuog1.png?width=268&format=png&auto=webp&s=61d4ccfcf84bb63089ecec872ebdfb191cacaf9e

submitted by /u/Icy_Earth266
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article