If you want the conditional formatting test to refer to a range on another
worksheet, you must use a Defined Name to refer to the cell on the other
sheet. For example, assign the name TheCell to Sheet2!A1. Then in the CF on
Sheet1, use

=TheCell="x"


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)

"jackrobyn1" wrote in message
...
In conditional formatting do you know what formula i can use for e.g the
cell
sheet1! A1 to change colour to orange if there is an "x" in the cell
sheet2!
B1 ?

thanks