Conditional formatting with IF

[barmstr6]

Hello,

I am need of assistance creating a chart. Currently we track performance on paper and I want to digitize but I cant get my conditional formatting correct. I want a line to be shaded green if below goal and where we finished but be shaded red if above goal and shaded where the performance ended up being.

Attached is a picture of current paper format.

Any help with a chart or if function would be greatly appreciated.

 

[severynm]

Hi! So there's no way to do this using traditional conditional formatting rules in excel. The common workaround seems to be using different series for each "rule" you want to have - plot one series with the red values and a second series with the green values. A quick google search finds us a few different articles on this topic exactly:

Conditional formatting for Excel column charts | Think Outside The Slide

www.thinkoutsidetheslide.com

Conditional Formatting of Excel Charts - Peltier Tech

It's easy to conditionally format an Excel worksheet, but not a chart. VBA can be used, but this article shows how to conditionally format charts without VBA.

peltiertech.com

How to create a chart with conditional formatting in Excel?

This guide provides step-by-step instructions on how to dynamically format chart elements, such as bars or lines, depending on the values they represent.

www.extendoffice.com