Forum Discussion
Conditional formatting based off first letter
Hello, I am trying to conditionally format a list of names based off the first letter in the cell. I want to have the cells containing A-L set to one format and M-Z as a different format. Is there ...
Hi, I've just tried this but it only works if one letter is entered in the cell. Have I done something wrong? Thanks 🙂
It should work for entries with more than one letter too:
See the attached sample workbook.