Thread
:
Conditional Formatting contains?
View Single Post
#
3
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett