Hello all,

I am trying to set conditional formats to the data table portion of my chart with no success. Under the graph (Plot Area) is the data table portion of the chart where I need to set up some conditional formatting. I need to color the cells according to what their number is. The way I have been getting around this is creating a text box, color fill it, then paste it over the cell in the data table. Doing some research I found that excel is very limited when it comes to formating the data table portion of a chart. Is there any way around this like a VB script? Hope I explained it well and thanks for any help. I am using excel 2003.