Need to created a Conditional formatting for the following:

Cells in rows J, R and Z contain data that needs the condition applied to.

Want to format the above cells with the following criteria:
The below is the criteria based on what percentage these values are off of the average value of these 3 cells
-20% to 20% Green
-30% to -20% and 20% to 30% Yellow
Less than -30% and Greater than 30% Red

I am able to perform this conditional formatting on a cell by cell basis with the following:
Condition 1:
Cell Value is Between -1.2*AC2 and 1.2*AC2 is Green
Cell Value is Between -1.2*AC2 and -1.3*AC2 is Yellow
Cell Value is Between 1.2*AC2 and 1.3*AC2 is Yellow
Cell Value is Greater than -1.3*AC2 is Red
Cell Value is Greater than 1.3*AC2 is Red

I want to see if there is a more effective way to do this against all the cells in rows J, R, and Z referenced against the average of the cells in row J, R, and Z data in all the cells in row AC

Example:
Row J Row R Row Z Row AC
12 16 8 12
Green Red Red

Let me know if you need further information and I appreciate any assistance or references you may be able to provide.


Submitted via EggHeadCafe - Software Developer Portal of Choice
How to Get Your Silverlight Pages Indexed By Search Engines
http://www.eggheadcafe.com/tutorials...silverlig.aspx