fordintern
New Member
- Joined
- Jun 13, 2013
- Messages
- 3
Im not good with macros at all and I need help.
For the Green cell, I want it to turn green if the number is <+-10%
For the Red Cell, I want it to turn green if the number is greater than >+-10%
TO calculate the percentages at the bottom, follow this formula,
SlopeX50° / D$6-D$7
D6= 0.00035
D7= -0.00035
I can also email you my excel file, if you have any questions. Because I have no ideal how to make macros in excel for this. Thanks for the help. Much appreciated.
[TABLE="width: 602"]
<COLGROUP><COL style="WIDTH: 117pt; mso-width-source: userset; mso-width-alt: 5705" width=156><COL style="WIDTH: 50pt; mso-width-source: userset; mso-width-alt: 2450" width=67><COL style="WIDTH: 124pt; mso-width-source: userset; mso-width-alt: 6034" span=3 width=165><COL style="WIDTH: 63pt; mso-width-source: userset; mso-width-alt: 3072" width=84><TBODY>[TR]
[TD="class: xl65, width: 156, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 67, bgcolor: transparent, align: right"]115.00000[/TD]
[TD="class: xl69, width: 165, bgcolor: transparent, align: right"]-0.00135[/TD]
[TD="class: xl69, width: 165, bgcolor: transparent, align: right"]-0.00122[/TD]
[TD="class: xl69, width: 165, bgcolor: transparent, align: right"]-0.00042[/TD]
[TD="class: xl69, width: 84, bgcolor: transparent, align: right"]-0.00043[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]112.00000[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00137[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00125[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00041[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00044[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]110.00000[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00136[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00124[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00036[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00041[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]104.00000[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00134[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00125[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00031[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00036[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]103.00000[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00133[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00123[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00033[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00036[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]102.00000[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00134[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00125[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00034[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00039[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]99.20000[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00133[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00124[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00031[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00035[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]97.10000[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00130[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00123[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00033[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00035[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]95.30000[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00135[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00125[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00033[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00037[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]93.50000[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00133[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00124[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00031[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00034[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]91.50000[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00132[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00125[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00033[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00035[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]89.70000[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00134[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00126[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00036[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00039[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]87.60000[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00134[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00126[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00035[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00038[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]85.40000[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00133[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00126[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00034[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00040[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]84.50000[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00134[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00126[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00032[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00038[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Slope[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]-0.0000008[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]0.0000009[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]-0.0000020[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]-0.0000015[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Slope X 50°[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]-0.000042[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]0.000044[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]-0.000098[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]-0.000074[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]as percent[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: #99ff99, align: right"]-5.9%[/TD]
[TD="class: xl71, bgcolor: #99ff99, align: right"]6.2%[/TD]
[TD="class: xl70, bgcolor: #ff0066, align: right"]-16.4%[/TD]
[TD="class: xl70, bgcolor: #ff0066, align: right"]-12.4%[/TD]
[/TR]
</TBODY>[/TABLE]
For the Green cell, I want it to turn green if the number is <+-10%
For the Red Cell, I want it to turn green if the number is greater than >+-10%
TO calculate the percentages at the bottom, follow this formula,
SlopeX50° / D$6-D$7
D6= 0.00035
D7= -0.00035
I can also email you my excel file, if you have any questions. Because I have no ideal how to make macros in excel for this. Thanks for the help. Much appreciated.
[TABLE="width: 602"]
<COLGROUP><COL style="WIDTH: 117pt; mso-width-source: userset; mso-width-alt: 5705" width=156><COL style="WIDTH: 50pt; mso-width-source: userset; mso-width-alt: 2450" width=67><COL style="WIDTH: 124pt; mso-width-source: userset; mso-width-alt: 6034" span=3 width=165><COL style="WIDTH: 63pt; mso-width-source: userset; mso-width-alt: 3072" width=84><TBODY>[TR]
[TD="class: xl65, width: 156, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 67, bgcolor: transparent, align: right"]115.00000[/TD]
[TD="class: xl69, width: 165, bgcolor: transparent, align: right"]-0.00135[/TD]
[TD="class: xl69, width: 165, bgcolor: transparent, align: right"]-0.00122[/TD]
[TD="class: xl69, width: 165, bgcolor: transparent, align: right"]-0.00042[/TD]
[TD="class: xl69, width: 84, bgcolor: transparent, align: right"]-0.00043[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]112.00000[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00137[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00125[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00041[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00044[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]110.00000[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00136[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00124[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00036[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00041[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]104.00000[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00134[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00125[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00031[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00036[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]103.00000[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00133[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00123[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00033[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00036[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]102.00000[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00134[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00125[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00034[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00039[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]99.20000[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00133[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00124[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00031[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00035[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]97.10000[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00130[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00123[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00033[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00035[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]95.30000[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00135[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00125[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00033[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00037[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]93.50000[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00133[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00124[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00031[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00034[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]91.50000[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00132[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00125[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00033[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00035[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]89.70000[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00134[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00126[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00036[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00039[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]87.60000[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00134[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00126[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00035[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00038[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]85.40000[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00133[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00126[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00034[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00040[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]84.50000[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00134[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00126[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00032[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.00038[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Slope[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]-0.0000008[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]0.0000009[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]-0.0000020[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]-0.0000015[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Slope X 50°[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]-0.000042[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]0.000044[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]-0.000098[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]-0.000074[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]as percent[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: #99ff99, align: right"]-5.9%[/TD]
[TD="class: xl71, bgcolor: #99ff99, align: right"]6.2%[/TD]
[TD="class: xl70, bgcolor: #ff0066, align: right"]-16.4%[/TD]
[TD="class: xl70, bgcolor: #ff0066, align: right"]-12.4%[/TD]
[/TR]
</TBODY>[/TABLE]