formula cannot do that but conditional formatting will.

"ExcelQuestion" wrote:

Hello all,

=CONCATENATE(IF(C91.15*D8,"SELL","
"),IF(AND((D8*1.15=C9),(D8*1.05<=C9)),"HOLD", "
"),IF(AND((D8*1.05C9),(D8*0.95<=C9)),"APPROAC HING BUY","
"),IF(C9<0.95*D8,"BUY"," "))

How can i return a bold red "Sell" for this function?