| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formatting / Positive vs. Negative
Conditional Formatting
I want to change the font color of a number that is the negative value of another number. I could conditionally format each cell individually, but that would be too time-consuming (lots of numbers.) For example; D5 = 22,443 & D12 = (22,443) If one cell is the opposite of another cell, change the font color to hide the negative value. Any help would be appreciated€¦ Thx in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting based on positive/negative numbers | Excel Discussion (Misc queries) | |||
| CONDITIONAL FORMATTING & NEGATIVE VALUES | Excel Worksheet Functions | |||
| Subtracting positive amts from negative and positive from positive | Excel Worksheet Functions | |||
| Conditional Formatting - colored arrow showing positive trend | Excel Discussion (Misc queries) | |||
| Formula to make Negative Values Positive & Positive Values Negative? | Excel Discussion (Misc queries) | |||
Threaded Mode
