you can conditional format the actual cell itself but you seem to have to do
each cell separately,cos the formula of Len(a1)4 stays absolute within the
conditional format bar
--
paul
remove nospam for email addy!



"cjjoo" wrote:


so is there a way to format the source to hightlight the last number
using conditional formatting?


--
cjjoo
------------------------------------------------------------------------
cjjoo's Profile: http://www.excelforum.com/member.php...o&userid=26916
View this thread: http://www.excelforum.com/showthread...hreadid=479326