View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jostlund jostlund is offline
external usenet poster
 
Posts: 18
Default 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.