| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fill color if amount is negative
If the cell in COL J contains a negative value, how do I add a yellow fill color to that row?
Here's a portion of my spreadsheet: -1398.88 3569.94 7022.00 75.95 -5051.24 5165.80 834.82 282.40 17991.89 809.63 -114.02 138.73 -1.16 19.81 45.72 0.00 35.22 19.81 45.65 19.81 335.61 396.39 712.66 19.34 576.78 69.21 -127.36 607.36 1715.71 125.66 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Fill color if amount is negative
GWC used his keyboard to write :
If the cell in COL J contains a negative value, how do I add a yellow fill color to that row? Here's a portion of my spreadsheet: -1398.88 3569.94 7022.00 75.95 -5051.24 5165.80 834.82 282.40 17991.89 809.63 -114.02 138.73 -1.16 19.81 45.72 0.00 35.22 19.81 45.65 19.81 335.61 396.39 712.66 19.34 576.78 69.21 -127.36 607.36 1715.71 125.66 Already asked and answered! -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fill color when negative | Excel Programming | |||
| Change of negative amount | Excel Discussion (Misc queries) | |||
| Formula with negative amount | Excel Discussion (Misc queries) | |||
| fill color to a cell when the value is negative or positi | Excel Programming | |||
| Deleting a negative sign from an amount in a list (not trailing negative) | Excel Programming | |||
Hybrid Mode
