I have a list of student usernames for our website. Generally the default is
firstname.lastname but some students have firstname1.lastname. I am trying to
identify all the students with firstname1.lastname and I would like to run a
conditional format that identifies all cells that contain the number 1 (even
if it is part of a word, in this case name.

Thanks