•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to automate conditional formatting
Alright, I have a work spreadsheet that has two columns; lot number and serial number. Serial numbers are always unique, lot numbers are not. Out if a hundred items in the list there maybe 8 unique lot numbers.
I want to highlight every entry by lot number, and I would like it set up in such a way that everytime I enter a new lot number it gets assigned it’s own color. Initially I was thinking about using conditional formation g (hence the title) but I am not sure that that can be automated.
Is there a way to do this? And I just being dumb?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#modern spreadsheet innovations
#machine learning in spreadsheet applications
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software
#automated anomaly detection
#Excel compatibility
#collaborative spreadsheet tools
#AI-driven spreadsheet solutions
#cloud-based spreadsheet applications
#Excel alternatives for data analysis
#automation in spreadsheet workflows
#no-code spreadsheet solutions
#AI-powered spreadsheet
#Excel alternatives
#spreadsheet API integration
#conditional formatting
#lot number
#Excel
#spreadsheet