Excel 2003 Identify a single character in column
 

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

Excel 2003 Identify a single character in column
 

Select the range to be impacted, with A1 as the active cell

<format<conditional formatting
Condition_1:
Formula is: =COUNTIF(A1,"*1.?*")
Click the [format] button....set the format you want
Click the [OK] buttons

That will flag any entry containing a 1 followed by a period and at least
one character.

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)

"Charles Tippie" <Charles wrote in message
...
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

Excel 2003 Identify a single character in column
 

It worked great!! Thank you for your help!

"Ron Coderre" wrote:

Select the range to be impacted, with A1 as the active cell

<format<conditional formatting
Condition_1:
Formula is: =COUNTIF(A1,"*1.?*")
Click the [format] button....set the format you want
Click the [OK] buttons

That will flag any entry containing a 1 followed by a period and at least
one character.

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)

"Charles Tippie" <Charles wrote in message
...
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