Can I do a conditional formatting on a cell that is not the same w

[Option Button]

Can I do a conditional formatting on a cell that is not the same where the
conditions are at?
Let assume that in my model the cell B10 represent a profit or loss of the
project.
In cell B12, I have some text and I want it to be displayed in black if the
value in cell B10 is positive and the text to be displayed in red if the
value in cell B10 is negative.
How do I go about formating cell B12 using conditional formatting?

 

[Gary''s Student]

Sure.

Use the FormulaIs option rather than referring to the value.

 

[Sheeloo]

Select B12
Choose FORMULA IS option for Conditional Formatting...
Enter
=B10>=0
for positive condition and choose the formatting
and
=B10<0
for negative condition and choose the formatting

If it does not work then go back and make sure that no quotes are added
around the formula ...

 

[Luke M]

Open up the conditional format box. Change first box to "Formula is"
In second box, type:
=B10>=0
Similarly, second condition is
=B10<0

Format as you desire.

 

[Gord Dibben]

Select B12 and Format>CF>Formula is.

=B10<0 Format to red font.

Since Black font is default......usually.........no condition need be set
for positive number.


Gord Dibben MS Excel MVP