cell conditional formatting
 

I have a cell Q144 that I would like to place conditional
formatting into. But it depends on the cell (I144) that
will either have "X" in it or not. If I144 does have
the "X" then I would like to have Q144 multiply 2 cells
(K144 * N144) and have the cell Q144 say "Lost (whatever
the dollar amt is). I am having a quandry of what to
place in the conditional formatting formula line for
Q144. If anyone can assist, thanks.
*** John

cell conditional formatting
 

Hi
this is not a conditional formating issue but a formula issue :-)
Enter the following formula in cell Q144
=IF(I144="X","Lost " & K144*N144,"")


--
Regards
Frank Kabel
Frankfurt, Germany

"John" schrieb im Newsbeitrag
...
I have a cell Q144 that I would like to place conditional
formatting into. But it depends on the cell (I144) that
will either have "X" in it or not. If I144 does have
the "X" then I would like to have Q144 multiply 2 cells
(K144 * N144) and have the cell Q144 say "Lost (whatever
the dollar amt is). I am having a quandry of what to
place in the conditional formatting formula line for
Q144. If anyone can assist, thanks.
*** John

cell conditional formatting
 

Conditional formatting can't change the value in a cell, only the font
or background.

You can enter this in Q144:

=IF(I144="X","Lost " & TEXT(K144*N144,"$#,##0.00"),"")

In article ,
"John" wrote:

I have a cell Q144 that I would like to place conditional
formatting into. But it depends on the cell (I144) that
will either have "X" in it or not. If I144 does have
the "X" then I would like to have Q144 multiply 2 cells
(K144 * N144) and have the cell Q144 say "Lost (whatever
the dollar amt is). I am having a quandry of what to
place in the conditional formatting formula line for
Q144. If anyone can assist, thanks.
*** John