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?

Sure.

Use the FormulaIs option rather than referring to the value.
--
Gary''s Student - gsnu200839


"Option Button" wrote:

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?

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


"Option Button" wrote:

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?

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Option Button" wrote:

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?

Select B12 and FormatCFFormula 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

On Mon, 16 Mar 2009 12:22:01 -0700, Option Button
wrote:

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?