| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formatting in BOLD and RED in cell
I have this:
=IF(region_selected="All","AMF="& AC9 &" , APJ="& AC10 &" , EMEA="& AC11 & " , Total=" & AC12,"Destination ("&VLOOKUP(region_selected,AB9:AC12,2,FALSE)&") ") If one region is selected the result may look like this : Destination (24) If 'All' is selected the result may be: AMF=24 , APJ=20 , EMEA=17 , Total=61 I would like to have the numbers BOLD and RED. How can I do it in Excel 2007 (without VBA)? C02C04 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formatting in BOLD and RED in cell
hi
do you mean just the numbers? no matter.... this can be done with hard text but not with numbers or formulas sorry regards FSt1 "C02C04" wrote: I have this: =IF(region_selected="All","AMF="& AC9 &" , APJ="& AC10 &" , EMEA="& AC11 & " , Total=" & AC12,"Destination ("&VLOOKUP(region_selected,AB9:AC12,2,FALSE)&") ") If one region is selected the result may look like this : Destination (24) If 'All' is selected the result may be: AMF=24 , APJ=20 , EMEA=17 , Total=61 I would like to have the numbers BOLD and RED. How can I do it in Excel 2007 (without VBA)? C02C04 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formatting in BOLD and RED in cell
Yes, just the numbers.
Okie, at least I can stop trying and tell my boss it can't be done. ;-) C02C04 "FSt1" wrote: hi do you mean just the numbers? no matter.... this can be done with hard text but not with numbers or formulas sorry regards FSt1 "C02C04" wrote: I have this: =IF(region_selected="All","AMF="& AC9 &" , APJ="& AC10 &" , EMEA="& AC11 & " , Total=" & AC12,"Destination ("&VLOOKUP(region_selected,AB9:AC12,2,FALSE)&") ") If one region is selected the result may look like this : Destination (24) If 'All' is selected the result may be: AMF=24 , APJ=20 , EMEA=17 , Total=61 I would like to have the numbers BOLD and RED. How can I do it in Excel 2007 (without VBA)? C02C04 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting? Bold | Excel Worksheet Functions | |||
| Bold Text Formatting | Excel Discussion (Misc queries) | |||
| euro symbol loses formatting if bold | Excel Discussion (Misc queries) | |||
| Join bold and non-bold text in one cell | Excel Discussion (Misc queries) | |||
| BOLD formatting no longer works after reinstal | Setting up and Configuration of Excel | |||
Hybrid Mode
