conditional formatting

[Guest]

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

 

[Peo Sjoblom]

1.

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

_Sheet2B1


2.
Select Sheet1 A1 and do format>conditional formatting and select formula is

=_Sheet2B1="x"

click the format button>patterns and select orange then click OK twice

 

[Chip Pearson]

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)