Conditional Formatting in another cell

[Nick Scherzer]

Is there a way to do conditional formatting based on the
value in a different cell? For example, if the value in
Cell B1 is 0, then I want to make Cell A1 bold and color
it red.

 

[Peo Sjoblom]

Select A1, do format>conditional formatting, in the formula is box put

=($B$1=0)*(LEN($B$1)>0)

click the format button and format it to your satisfaction

 

[Paul B]

Nick, conditional format A1 as formula is =$B$1=0 and set it to bold and
red
--
Paul B
Always backup your data before trying something new
Using Excel 97 & 2000
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **

 

[Dan E]

Nick,

Select cell A1 and choose Format -> Conditional Formatting
In your conditional formatting window choose Formula Is and
enter "=$B$1 = 0" (without quotes). Then set your format
(bold or whatever) and hit OK

Dan E

 

[Peo Sjoblom]

Just a heads up, if B1 can be blank as well, that formula will change the
format..

 

[Nick Scherzer]

Works like a charm, thanks Peo!

-----Original Message-----
Select A1, do format>conditional formatting, in the formula is box put

=($B$1=0)*(LEN($B$1)>0)

click the format button and format it to your satisfaction
--

Regards,

Peo Sjoblom





.

 

[Dan E]

Yeah, I assumed it was a formula that would give varying results (hence
using it as the source of the condition) but, you could be right.

Dan E