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

Book1.xlsx (15.4 KB, 15 views)

I am not sure if this can be done but if it can I'd like to see an answer.

In my experience, I have not figured out how to do it. I can conditionally format a cell based on its value, it's value relative to a constant, or its value relative to another cell. The last we can apply over a range of cells resulting in each individual cell conditionally formatted to a specific referent cell.