Hey EPAC, hopefully you're still here. I wanted to revise my previous question to make it a little more detailed. The initial question can be found here:
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_23617818.htmlPreviously, we had created a spreadsheet that changes color according to data. For an example, please see the link above. My idea was to create an average number for a row based on the data.
1) Create an average for the data in B1 - B80. When data is input into B81 the cell color changes according to the size to the previous average of that row. So if the data input was below 5% it would turn red. If the data was above 5% it would turn green.
2) I want to take the concept of 1) and expand it a little bit. I would like the cell to turn red if the average is below 5%. Anything above I would want to turn green. Previously it was set to turn red below 5% and green above 5%. Anything in between and no color would appear. Coming from a programming perspective:
IF data = <5% color = red ELSE color = green.
3) Previously this was applied to the whole column, for example all of B. However, the first column (A) lists the date on the side followed by the amount. After each month I would like a break in the middle that displays the average for that month. However, I do not want each month's calculated average between cells to have a factor in the data manipulation. Basically, just a visual aid. So lets say I have two months.
9/1 450
9/2 430
etc....
9/30 460
9/31 480
September Average = 455 <--- This number does not factor into the data average
10/1 540
10/2 520
etc....
10/30 580
10/31 545
October Average = 560 <--- This number does not factor into the data average
Thank you so much, I'm illiterate when it comes to Excel, but I have ideas! :-)
Start Free Trial
