Formula/Conditional Formatting

		Microsoft Office Forums > Microsoft Excel > Excel
Formula/Conditional Formatting

FAQ

Thread Tools

Display Modes

04-15-2014, 12:21 PM

teza2k06

Windows 7 64bit Formula/Conditional Formatting

Office 2010 32bit

Advanced Beginner

Join Date: Feb 2013

Posts: 38

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

Book1.xlsx (15.4 KB, 15 views)

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:16 AM.