1.

Name Sheet2 B1 something, just select it, click in the name box (name box
is above column A's header) or use insertnamedefine and type a descriptive
name like (note the underscore at the start)

_Sheet2B1


2.
Select Sheet1 A1 and do formatconditional formatting and select formula is

=_Sheet2B1="x"

click the format buttonpatterns and select orange then click OK twice

--

Regards,

Peo Sjoblom




"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