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?