Hi Guys,

I created several charts based on data I collect daily. This data always changes so I wanted the info to change background color based on the number value. I used conditional formatting. I'm having a difficult time trying to get vba to accept the conditional formatting color. I guess the background isn't the true color, so it inserts white instead. Here's my constraints for my worksheet:

Contraints
1) I have one worksheet that has both the charts and information
2) The name of the chart will vary every so often (i.e. today the name is "Apple", but tomorrow the name can be "Banana")
3) There are several charts on the worksheet, but they all have different cell ranges of information and they all must chane based on the conditional formatting value
4) I'm using MS Excel 2013
5) I used conditional formatting rules (>, blue), (<, red), and (between to percentages, yellow)

So here what my code looked like:

Please Login or Register  to view this content.
Any help will be greatly appreciated. Thanks!