View Single Post
 
Old 04-15-2014, 12:21 PM
teza2k06 teza2k06 is offline Windows 7 64bit Office 2010 32bit
Advanced Beginner
 
Join Date: Feb 2013
Posts: 37
teza2k06 is on a distinguished road
Default 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.
Attached Files
File Type: xlsx Book1.xlsx (15.4 KB, 15 views)
Reply With Quote