conditional formatting or VBA to display text

Bear in mind I am working with Excel 2000

If cell D4 has a 90 or above, I want cell C4 to highlight in green, but I also want the cell to display the word green. I know how to do the former, but the latter perplexes me a bit.

Any suggestions?

Thanks in advance

Originally Posted by Tony Valko

You would have to enter a formula in cell C4. Something like this...

=IF(N(D4)>=90,"Green","")

Or, this very robust version:

=IF(ISNUMBER(D4),IF(D4>=90,"Green",""),"")

Pretty clever Tony, what if i wanted to add another variable, so that any number between 80-89 will display the text "yellow"

Thanks

Originally Posted by Tony Valko

Like this...

=IF(ISNUMBER(D4),IF(AND(D4>=80,D4<=89),"Yellow",IF(D4>=90,"Green","")),"")

Thanks a bunch and one last bit of help if you don't mind

I am trying to add one last variable for Red, but something is not quite right. I keep getting a value message.

=IF(ISNUMBER(D4),IF(AND(D4>=0,D4<=79,"Red",IF(D4>=80,D4<=89),"Yellow",IF(D4>=90,"Green","")),""))

Awesome!!!

Thanks a bunch.
Go Bangels!!!!!