View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mcb223 mcb223 is offline
external usenet poster
 
Posts: 2
Default Using IF to return more than text

I would like my IF formula to output in the cell both Text and change color
of the output cell, but when I'm constructing the formula the Paintcan colors
become greyed out and seems like only text is allowed.

For instance if a cell is greater than another cell's value, I would like
the output cell to turn red as well as say "Alert". Any way to do this?
--
Matt B.