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

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

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