Format|conditional formatting won't help you in this case.

If you look at the output, you'll see the Bob actually changed your data by
combining it nicely.

hamster wrote:

Wow that was fast!

How I can I this Format- Conditional Formatting in Excel?

Thanks and again much appreciated.
James.

--
hamster
------------------------------------------------------------------------
hamster's Profile: http://www.excelforum.com/member.php...o&userid=28706
View this thread: http://www.excelforum.com/showthread...hreadid=483903

--

Dave Peterson