Line & Clustered Column Chart - Conditional Formatting?

[kressb]

Hello, I have a line and clustered column chart that looks like this:

 

any ideas on how to get conditional formating so that either the background or text or even the bar turns red if it's above 2%?

Only thing I can see is to do it manually under Data Colors --> Show All which wont work, because then the bar stays red when the slicer is used.

TYIA

[MFelix · Accepted solution]

Hi @kressb ,

On the Data color options of the chart you will have 2 options first one is regarding the line values and the second one that sould say default color.

On the second one if you check the rigth side it will appear 3 dots where you can select the conditional formatting then just set your rule.

Don't forget to set the option on the rules to number instead of percent.

Regards.

MFelix