G GODZILLA New Member Nov 26, 2010 #1 Hello, I think i have an interesting question. Can you use a formula to change the size of text? I have a list of names and ranks. I want the higher ranked names to be larger. Any idea?
Hello, I think i have an interesting question. Can you use a formula to change the size of text? I have a list of names and ranks. I want the higher ranked names to be larger. Any idea?
X xld Member Nov 26, 2010 #2 In a word, no. You can use VBA event code to trap the value as input and change it, but not a formula.
In a word, no. You can use VBA event code to trap the value as input and change it, but not a formula.
Luke M Excel Ninja Staff member Nov 29, 2010 #3 If using Bold, Italics, or colors would work, you can always use Conditional formatting.
Hui Excel Ninja Staff member Nov 30, 2010 #4 You can use Conditional Formatting to set the Text Size You will need to add a condition for each Rank/Size combination you want Using Excel 2007/10 will enable more than 4 combinations to be used.
You can use Conditional Formatting to set the Text Size You will need to add a condition for each Rank/Size combination you want Using Excel 2007/10 will enable more than 4 combinations to be used.
