Excel Formatting Puzzle

[mccornack]

Hello everybody, I've come with my second of three questions for the evening. This one involves formatting cells of text based on the number value in the cell below it. The higher the number, the larger I want the font, and the darker I want the color. If the number is zero, I want no change to the text.

If we have the following cells (please imagine this as 8 different cells)

the quick brown fox
0 1 3 2

we would get something to the effect of:


the quick brown fox

For the sake of my project, I need separate code for a red macro and a green macro. However, if the meat of the code is there I'm sure I can tweak it to fix the color scheme. Any help is greatly appreciated! Please let me know if you have any questions. Thank you!!

 

[konew1]

Do you really want a macro? Why not just use conditional formatting. (If you have excel 2007 or 2010)

 

[Rick Rothstein]

If we have the following cells (please imagine this as 8 different cells)

the quick brown fox
0 1 3 2

What is the range of numbers? How much should the font size increase with each next higher number?

 

[mccornack]

Do you really want a macro? Why not just use conditional formatting. (If you have excel 2007 or 2010)

I'm not sure if I want a macro, I took a look at conditional formatting, but wasn't convinced I could pull off what I wanted.

What is the range of numbers? How much should the font size increase with each next higher number?

The range of numbers goes from 0-9. Here's the number-value/font size break down I need:
0 8
1-2 10
3-4 12
5-6 14
7+ 16

Thanks so much for your help with this, please let me know if you need any more info!