Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
using colour within a formula
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
colour in a formula | Excel Discussion (Misc queries) | |||
formula for colour | Excel Worksheet Functions | |||
How do I save new colour schemes for graphs in the colour template | Charts and Charting in Excel | |||
change a cell background colour to my own RGB colour requirements | Excel Discussion (Misc queries) | |||
Text in Blue colour, but print in black colour | Excel Worksheet Functions |