Formatting one cell based on the contents of another cell

[A.C.G.]

Hello. I am trying to format one cell based on the contents of
another. Specifically, I have a drop-down menu in D11, there are about
10 different text lines you can choose from. Five of them are phrases
relating to percentages and the other five are phrases relating to
regular numbers. What I need to happen (preferably with a formula, not
a macro) is . . when you choose a phrase in D11 that deals with a
percetnage, I need D12 to be formatted as %, whereas if you choose a
phrase that deals with numbers it formats D12 as NUMBER. What I have
done so far is to use an OR statement in Conditional Formatting that
says: =OR(D11="Percentage Phrase 1",D11=Percentage Phrase 2", etc) and
then have it format the cell as a percentage (This is in Excel 2007 by
the way). If I leave cell D12 formatted as a number, you'd think it
would change it to a percentage only if one of the 'percentage
phrases' are chosen (and that part does work). The problem is, once
you've chosen a percentage phrase and it formats D12 as a percentage,
if you then choose a 'Number Phrase" it does not change the formatting
back to 'Number'. I even tried putting a 2nd conditional formatting
rule in, much like the first one but this one as =OR(D11="Number
Phrase 1", D11="Number Phrase 2", etc), but becasue the rules run in a
certain order once you've made one of each choice it stays with the
formatting of the 2nd choice and will not change back to the correct
one based on the drop-down choice. Any ideas?

 

[Yetta]

Is this your list:
Number Phrase 1
Number Phrase 2
Number Phrase 3
Number Phrase 4
Number Phrase 5
Percentage Phrase 1
Percentage Phrase 2
Percentage Phrase 3
Percentage Phrase 4
Percentage Phrase 5
Or just samples... because it's important to know the exact choices to make
this work.

 

[A.C.G.]

Just samples, The real ones are below.

When these ones are chosen I need the cell formatted as a percentage:
Activation Fee
Call Coding
Connects
Credit Scoring
Digital Sell-in
H.S.I. Sell-in
QA Score
QC Score
Sales Flow
Telephony Sell-in
Three Product Sell-in
Two Product Sell-in

When these ones below are chosen I need the cells formatted as a Number:
Average Handle Time
Average Hold Time
Average Talk Time
Average Wrap Time