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.

Assume your % starts in F1 and the words Auto, Boiler... are in column C:

Highlight the data in column F and then
Choose Format, Conditional Formatting, and change the first drop down to
Formula is and enter the following formula:

=AND(OR(F10.1,F1<-0.1),C1="Auto")

Set a color under Format, then OK once, and then Add a second condition.
This will work the same as above but change the word Auto to Boiler. Repeat
up to three conditions.

--
Cheers,
Shane Devenshire


"jostlund" wrote:

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.

Thanks Shane, that works! Now I just need to figure out the process for
dealing with more than 3 conditions!


"ShaneDevenshire" wrote:

Assume your % starts in F1 and the words Auto, Boiler... are in column C:

Highlight the data in column F and then
Choose Format, Conditional Formatting, and change the first drop down to
Formula is and enter the following formula:

=AND(OR(F10.1,F1<-0.1),C1="Auto")

Set a color under Format, then OK once, and then Add a second condition.
This will work the same as above but change the word Auto to Boiler. Repeat
up to three conditions.

--
Cheers,
Shane Devenshire


"jostlund" wrote:

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.

Not so simple, buy 2007! Excel 2003 will only handle 3 conditions. You
could write a macro to do it, but in 2007 there is no limit on the number of
conditions.
--
Cheers,
Shane Devenshire


"jostlund" wrote:

Thanks Shane, that works! Now I just need to figure out the process for
dealing with more than 3 conditions!


"ShaneDevenshire" wrote:

Assume your % starts in F1 and the words Auto, Boiler... are in column C:

Highlight the data in column F and then
Choose Format, Conditional Formatting, and change the first drop down to
Formula is and enter the following formula:

=AND(OR(F10.1,F1<-0.1),C1="Auto")

Set a color under Format, then OK once, and then Add a second condition.
This will work the same as above but change the word Auto to Boiler. Repeat
up to three conditions.

--
Cheers,
Shane Devenshire


"jostlund" wrote:

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.