| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting
I am trying to format cells that meet the following criteria +/- 10,000 AND
(greater than 20% OR less than (-)20%). I can't get the rules to recognize the negative 20%. I'm not sure if this is my issue or not. I only want one highlighting color. My sample is below. I'm applying the format to the 3rd column and do not want the calculation in the 4th unless necessary. The % change referenced above is column 3/column 1. PM CM Change 10 20 -10 -100% 10000 0 10000 100% 12000 0 12000 100% 0 12000 -12000 #DIV/0! 20000 3000 17000 85% 20000 24000 -4000 -20% 0 #DIV/0! 2000000 2200000 -200000 -10% 2000000 2600000 -600000 -30% Help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I convert conditional formatting into explicit formatting? | Excel Discussion (Misc queries) | |||
| Formatting Conditional Formatting Icon Sets | Excel Discussion (Misc queries) | |||
| Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Threaded Mode
