How to make conditional formatted charts in Excel

== How to conditionally format a chart or change the formatting of a chart’s plotted points (markers, bar fill color, etc.) based on the values of the points, can be done by using VBA to change the individual chart elements or values, but the code must be run whenever the data changes to maintain the formatting.The purpose is get our charts with different colored points depending on the points’ values, and no need to resort macros: -
1- click on line or bar to makes a simple unformatted chart.
-
2- the conditional formatting of worksheet ranges requires formulas to determine which cells should take on the formatting.
In the same way, we will use formulas to define the formatting of series in the charts.So, we will replace the original plotted data in the line and bar charts with several series, one for each set of conditions of interest., i.e.,50-100 (red),100 -105 (blue) and105-120 (green).
-
3- The formatting limits are inserted into rows1 and2.
The header formula in cell C3, which is copied into D3:E3, is [ =C1&"

Its a some much longer process but with the help of different type of codes we can make it easy

1- shade the table you want to apply conditional formatting on it
2- choose the conditional formatting rule.
3- choose the condition.
and thats it :)

Coordination will be using blue and red nicest parties with ease and control the images and blending knotted التنسيق يكون باستخدام اللونين الأزرق والأحمر اجمل مع تخفيف الاطراف ومراقبة ظل الصور والمزج المحبوك