Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sorting a range with conditional formatting | Excel Worksheet Functions | |||
conditional formatting glitches | Excel Discussion (Misc queries) | |||
Keeping conditional formatting when sorting | Excel Discussion (Misc queries) | |||
conditional formatting | Excel Discussion (Misc queries) | |||
cannot use ISEVEN or ISODD functions in Conditional Formatting | Excel Worksheet Functions |