shaftdx
Board Regular
- Joined
- Aug 20, 2018
- Messages
- 136
- Office Version
- 2011
- Platform
- MacOS
Ok so I know how to do regular common conditional formatting, I would like to know if there is a formula that I can type in that will get everything starting with the letter A-L in the alphabet to highlight and M-Z to be another color. I am working in a school bus yard and with COVID only certain kids are going in on certain days and I would like to be able to separate them by their last name