Conditional Formatting (IF function)

[Neo1]

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

 

[Bob Phillips]

Assuming data in column A

Select column A
Menu Format>Conditional 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]

The problem the Active and Inactive message doesnt work...its always on
Inactive....even when the statement ive used numbers that surely means
it has to be active but it still says Inactive

where do you think I've gone wrong?

Thanks
From John

 

[Pete_UK]

Hi John,

If you can paste the IF formula from your sheet then we might be able
to deduce why it isn't working.

Pete

 

[Neo1]

=IF('Main Menu'!J29>'Main Menu'!N4,"Active","Inactive")

I just click on the cell which i want to apply the If Statement
for...and for the part of 'Main Menu'!J29 its not meant to be from the
worksheet main menu which is where the IF formula is being put its meant
to be from another worksheet....what i did was just instead putting Main
Menu I put the name of the other worksheet and it worked.....but what im
curious about it why didnt it work when i just clicked the cell i wanted
it to be from the other worksheet?

Thanks
From John

 

[Neo1]

Basically what I want to do now is make the IF statment 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