Hello, I have a slight problem, I try to do conditional formatting for
the following IF Statement:

IF the number worked out from a division of number/9 numbers that
are added together to give say for example..600 , "Active","Inactive"

I want to put in Conditional Formatting so that if its active then I
want it to appear green and if its Inactive then in blue......


How can I do this

Thanks
From John


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