Excel 2003 Identify a single character in column

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Charles Tippie - 08 Sep 2007 16:56 GMT

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

Reply to this Message

Ron Coderre - 08 Sep 2007 17:09 GMT

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)

>I have a list of student usernames for our website. Generally the default
>is
[quoted text clipped - 7 lines]
>
> Thanks

Reply to this Message

Charles Tippie - 08 Sep 2007 19:16 GMT

It worked great!! Thank you for your help!

> Select the range to be impacted, with A1 as the active cell
>
[quoted text clipped - 26 lines]
> >
> > Thanks

Reply to this Message