=IF(I60,I6,"")

Put that forumula in AB2

"changetires" wrote:


Cell AB2 displays a positive number but in a red cell which indicates a
negative number.
Cell I6 is going to use this cell in its formula but only if it is a
red number not a green one. Green will indicate also a postive number
but in this case green number cell will not be used in the formula.
Can anyone help with this?

Ed


--
changetires
------------------------------------------------------------------------
changetires's Profile: http://www.excelforum.com/member.php...o&userid=35414
View this thread: http://www.excelforum.com/showthread...hreadid=555754