formatting in BOLD and RED in cell

[C02C04]

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

 

[FSt1]

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]

Yes, just the numbers.

Okie, at least I can stop trying and tell my boss it can't be done. ;-)


C02C04