formatting in BOLD and RED in cell

  • Thread starter Thread starter C02C04
  • Start date Start date
C

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
 
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
 
Yes, just the numbers.

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


C02C04
 
Back
Top