Look at the sample code provided with the FindNext method of the range
object (in Excel VBA help). It should be easily adaptable to your
requirement.

--
Regards,
Tom Ogilvy

"chrisrowe_cr"
wrote in message
news:chrisrowe_cr.1sw0en_1122566780.8384@excelforu m-nospam.com...

Hi all,

I need a bit of VB code to run off of a button which when clicked will
check a list of values (say in the range J2:J30) and format any other
cells on the worksheet to say bold blue text and italic that match the
range mentioned before.

Can anyone help with this?


--
chrisrowe_cr
------------------------------------------------------------------------
chrisrowe_cr's Profile:
http://www.excelforum.com/member.php...o&userid=25220
View this thread: http://www.excelforum.com/showthread...hreadid=390996