using colour within a formula

[Lise]

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

 

[Don Guillett]

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

 

[Conan Kelly]

Lise,

Why can't you just set the font color for B88,F8 to red?

If you can not for some reason, then you will need to:
(assuming the formula you listed is in G8)

1. Select "B88,F8"
2. Format > Conditional Formating...
3. Change the "Cell value is" dropdown to "Formula is"
4. Paste in this formula:
=$G8<>""
5. Click the "Format..." button and set text color to red

If your formula is in some cell other than G8, adjust the "$G8" to the
address of your cell.

HTH,

Conan

 

[Lise]

Thank Conan, yes have the original cells in red but not giving me the "look"
I wanted - tried your second option (thanks) and it changes the whole
sentence to red (is is helpful to use elsewhere as did not know that so great
new tip) Final outcome I'm after is that only those cells are red ane the
actual words used in the formula remain black...perhaps Don is right and
can't be done. Thanks for your assistance though

Lise

 

[Lise]

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

Lise

 

[Don Guillett]

CAN'T BE DONE!!