I have two worksheet. the second worksheet name "Financial" had one cell
link to first worksheet name FC_Rank
when the user select a factor on the first worksheet that factor name link
to cell A3 on the second sheet (=Financial!!A4) this name will lookup the
data and put in the correct format.

My question How can have a Macro when the user click the second worksheet
(FC_Rank tab) the format will change immediatley to the format i want?
Example 1 :
sale $
CY PY Chg to PY % Inc/dec
$100.00 $75.00 $25.00 33.3 % %
$456.00 500.00 -$44.00 11.23%
Example 2
Gas Gallon
CY PY Chg to PY % Inc/dec
1000.00 950.00 50.00 5.25%

Thanks

Liem