cell conditional formatting

J

John

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
 
F

Frank Kabel

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,"")
 
J

JE McGimpsey

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"),"")
 
Top