I have a cell in worksheet2 with reference to worksheet1.
I try to use conditional formatting but it give me error stating
"Cannot use references to other worksheet for conditional formatting
criteria".

How to solve this problem? Is there a way out?

Thank you.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/