LookIn:=xlValues, LookAt:=xlWhole
Lookin:=xlValues
says to look at what the formula produces and not at the formula itself.
Lookat:=xlWhole means the match must be to the whole value of the cell.
if you used xlpart, it would match "and" to "Sand" for example
--
Regards,
Tom Ogilvy
"chrisrowe_cr"
wrote in message
news:chrisrowe_cr.1t56yo_1122995160.4079@excelforu m-nospam.com...
hmm,
I tried this and woohoo it does work only it doesnt work...
I figured out why tho, the values I want to format are all being pulled
in via a lookup, is there anyway to make excel think they are just there
and not part of a formula?
--
chrisrowe_cr
------------------------------------------------------------------------
chrisrowe_cr's Profile:
http://www.excelforum.com/member.php...o&userid=25220
View this thread: http://www.excelforum.com/showthread...hreadid=392077