using colour within a formula
 

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

using colour within a formula
 

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

using colour within a formula
 

Lise,

Why can't you just set the font color for B8:D8,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 "B8:D8,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" 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

using colour within a formula
 

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

"Conan Kelly" wrote:

Lise,

Why can't you just set the font color for B8:D8,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 "B8:D8,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" 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

using colour within a formula
 

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

using colour within a formula
 

CAN'T BE DONE!!
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Lise" wrote in message
...
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

"Conan Kelly" wrote:

Lise,

Why can't you just set the font color for B8:D8,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 "B8:D8,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" 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