Forum Discussion
Conditional Formatting on a Donut Chart
Hi All! I'm working for an NGO and there financial reports are unclear so I'm preparing a dashboard for easy financial review. When illustrating ratios I want to depict these using donut chart...
Progress Doughnut Chart with Conditional Formatting in Excel
Assuming the data is in A1, then:
Assuming the data is in A1, then:
Home -> Conditional Formatting -> New Rule -> Use formula to determine which cells to format -> enter this formula and format the cell by color.
If =A1>0.5 (green)
If =A1=>0.51
If =A1=<0.80 (orange)
or
=AND($A1>0.51,$A1<0.80) (orange)
If =A1> 0.81 (Red)
Untested...but should work 🙂
Hope I was able to help you with this info.
I know I don't know anything (Socrates)