Michael,

It depends upon the formula you are using.

Post the formula, and the values being tested.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Michael168" wrote in message
...
I still have problem.
Range define as CFR=Sheet1!A10:F10 in sheet2
When I do conditional format in Sheet2, it seems the CFR can only take
Sheet1 column A range only and omits all the ranges for B:F.

Please kindly show me how to go about.

Thank you.



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