Thread: Conditional Formatting contains?

is there any way to use conditional formating if a cell contains rather than equals. For example highlight all cells that contain a 1 somewhere in the number.

so all these would highlight

10009

59991

91100

Use a condition of Formula Is and a formula of

=ISNUMBER(FIND("1",A1))

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"yorkshirewhite"
<yorkshirewhite.232thm_1139680501.7105@excelforum-nospam.com> wrote in
message news:yorkshirewhite.232thm_1139680501.7105@excelforum-nospam.com...
>
> is there any way to use conditional formating if a cell contains rather
> than equals. For example highlight all cells that contain a 1 somewhere
> in the number.
>
> so all these would highlight
>
> 10009
>
> 59991
>
> 91100
>
>
> --
> yorkshirewhite
> ------------------------------------------------------------------------
> yorkshirewhite's Profile:
http://www.excelforum.com/member.php...o&userid=31448
> View this thread: http://www.excelforum.com/showthread...hreadid=511367
>

try formula is

=find(1,h5)>0

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"yorkshirewhite"
<yorkshirewhite.232thm_1139680501.7105@excelforum-nospam.com> wrote in
message news:yorkshirewhite.232thm_1139680501.7105@excelforum-nospam.com...
>
> is there any way to use conditional formating if a cell contains rather
> than equals. For example highlight all cells that contain a 1 somewhere
> in the number.
>
> so all these would highlight
>
> 10009
>
> 59991
>
> 91100
>
>
> --
> yorkshirewhite
> ------------------------------------------------------------------------
> yorkshirewhite's Profile:
> http://www.excelforum.com/member.php...o&userid=31448
> View this thread: http://www.excelforum.com/showthread...hreadid=511367
>

Within Conditional formatting you only need

=find(1,a1)