As far as I can see, what I suggested will do exactly as you ask, and you
haven't told me differently, just that you don't want to use that. So if you
just reject what I offer then there is no point in me wasting my time.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"vumian" wrote in
message ...

hi Bob Phillips,

i know your way already, i do not want use that
i wanna use 'conditional formating' as my wrong formula above

how to fix it please. thanks


--
vumian
------------------------------------------------------------------------
vumian's Profile:
http://www.excelforum.com/member.php...o&userid=36494
View this thread: http://www.excelforum.com/showthread...hreadid=572676