Conditional Formatting in another cell

  • Thread starter Thread starter Nick Scherzer
  • Start date Start date
N

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.
 
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
 
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 **
 
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
 
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





.
Click to expand...
 
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
 
Back
Top