Assuming data in column A

Select column A
Menu FormatConditional Formatting
Change to Equal
Value of Active
Click the Format button
Select the Pattern Tab
Select green
OK
OK

Second condition

Click Add
Change to Equal
Value of Inactive
Click the Format button
Select the Pattern Tab
Select blue
OK
OK

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Neo1" wrote in message
...

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