|
|
#1
04-15-2014, 12:21 PM
|
|||
|
|||
Formula/Conditional Formatting
In column K i have a formula which show the remaining balance of some money.
How can i do it so that when the amount in column k is more than 0 then D2 is green and then when the total amount in column k is less than or equal to 0, then D2 turns red? If it is possible to do the above Please have a look at the attached then you will see what i mean by remaining balance. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Dragging conditional formatting like a formula
|
sjp1966 | Excel | 9 | 04-13-2017 06:01 AM |
| Excel Formula - Conditional replacement of cells | mag | Excel | 0 | 10-27-2012 08:30 PM |
| Conditional Formula | UICOMP | Excel | 1 | 05-18-2012 12:59 PM |
| Need formula for search and conditional formatting | MikeJedi | Excel | 9 | 01-13-2012 12:38 PM |
|
conditional formatting formula
|
NEHicks503 | Excel | 1 | 11-30-2011 09:01 AM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode