Basically what I want to do is make the IF statement I've made, green if
active and red if inactive...but stating that it has to be greater than
the number in cell A4 to be active thus green but less than the number
in A4 to be inactive thus red!

How can I do this?

Thanks a lot
From John


--
Neo1
------------------------------------------------------------------------
Neo1's Profile: http://www.excelforum.com/member.php...o&userid=30329
View this thread: http://www.excelforum.com/showthread...hreadid=518819