Yup, formatting = Conditional formatting worked.
And it is the fastest.
Thanks.
------------------------------------------------
~~ Message posted from
http://www.ExcelTip.com/
~~ View and post usenet messages directly from
http://www.ExcelForum.com/