•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Conditional formatting for specific character count
Hi! Hoping to have some assistance.
I have a spreadsheet of thousands of vehicles and VIN numbers. VINs are exactly 17 characters.
I need to conditional format (highlight) cells in which the character count is BELOW or ABOVE 17 characters. (Meaning the VIN was entered incorrectly.)
I can only find conditional formatting for values greater than/less than/equal to. In this case I’m not worried about the value, just the character count.
Any assistance would be appreciated, thank you!
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#modern spreadsheet innovations
#machine learning in spreadsheet applications
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software
#Excel compatibility
#collaborative spreadsheet tools
#AI-driven spreadsheet solutions
#cloud-based spreadsheet applications
#automation in spreadsheet workflows
#no-code spreadsheet solutions
#AI-powered spreadsheet
#Excel alternatives
#spreadsheet API integration
#conditional formatting
#VIN number
#character count