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