I am wondering how I can color code individual cells based on data from a table in a RadPivotControl. I do not want to color code the Totals rows or columns. My row has the values Neonate, Infant, Child, and Adult. My Columns are 2012, 2013, 2014. The color code is based on a national average of mortality rates and can change from one year to the next. So an expected value for a neonate in 2012 is between 1 and 2% while 2013 is 0.5-1.5%. If my neonate mortality rate in 2012 is 2% then I am GREEN. However if my mortality rate is 2% for 2013 then I am RED. Please let me know the best method to accomplish this.
Owen
Owen