Thread: Returning a colored value in If function
View Single Post
  #1   Report Post  
ExcelQuestion
 
Posts: n/a
Default Returning a colored value in If function
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?
Reply With QuoteReply With Quote