Can NOT do in a formula. Only if ALL text.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Lise" wrote in message
...
Hi - I am using this formula:
=IF(B8="",,B8 & " caused a " & D8 & " to the " & C8 & " due to " & F8)
which is filling in the detail I require, however I would like to make the
formula make B8, D8, C8 and F8 red text (as they are in their original
form)
Can anyone assist please.
Many thanks