# Conditional Formatting on a Donut Chart

Occasional Visitor

# 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 charts with the ratio in the middle of the donut for clarity.

To help staff understand the meaning of this ratio I want the appropriate donut segement to change colour if there is a problem. Normally I can do this on a single cell using conditional formating but for donut chart, i dont know how to do it.

For example: If< 0.5 (green). If between 0.51 and 0.80 (orange). If  > 0.81 (RED)

How can I do this?

# Re: Conditional Formatting on a 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

NikolinoDE

I know I don't know anything (Socrates)