Conditional formatting
Difference
$ %
Auto 1,813.00 Auto 1,663.00 -150.00 -8.27%
Boiler 280.00 Boiler 425.00 145.00 51.79%
Crime 103.00 Crime 321.00 218.00 211.65%
In the above example, how do I apply conditional formatting so the % change
is a different colour if Auto increased or decreased more than 10%, % change
cell to be red, if Boiler increased or decreased more than 10% than % change
cell to be green, if Crime increased or decreased more than 10% than % change
cell to be yellow, etc.
|