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


--
yorkshirewhite
------------------------------------------------------------------------
yorkshirewhite's Profile: http://www.excelforum.com/member.php...o&userid=31448
View this thread: http://www.excelforum.com/showthread...hreadid=511367

Conditional Formatting contains?
 

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@excelforu m-nospam.com wrote in
message news:yorkshirewhite.232thm_1139680501.7105@excelfo rum-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

Conditional Formatting contains?
 

try formula is

=find(1,h5)0

--
Don Guillett
SalesAid Software

"yorkshirewhite"
<yorkshirewhite.232thm_1139680501.7105@excelforu m-nospam.com wrote in
message news:yorkshirewhite.232thm_1139680501.7105@excelfo rum-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