Thanks Don - trying a couple of other options that Conan kindly offered, so
hopefully may get there yet :-)

Lise

"Don Guillett" wrote:

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