I have a simple spreadsheet to help track a budget. The spreadsheet is a running total of purchased items by department. I have a two-column chart that shows the total budget versus the budget spent (from cells A8 and A10 respectively). I also have two cells set up that calculate the percentage of the fiscal year gone (B8) and the percentage of the total budget spent (B10). What I need to do is have the budget spent column in the chart turn red if the percentage of the total budget spent is greater than the percentage of the fiscal year passed (IF(B8>B10, "turn the column red")). I've read several tutorials on conditionally formatting charts but haven't found an example that fits my situation. My condition (percentage of total budget spent vs percentage of fiscal year gone) are not part of the actual data series being plotted. I'm thinking, if this is even possible, that VBA will have to be used. If someone could please point me in the right direction I would greatly appreciate it.
Thanks in advance.