Conditional formatting in Excel

[atswimtwolengths]

Hope someone can help. I've used this a lot, but I've been given a task to do which has to be done using conditional formatting and I can't do it! I know it can be done as others have done it. (I'm a teacher and it's something from a pre-set assignment.)

I need to say if one particular cell is greater than another cell, then OK should be entered, if it's not, then ORDER should be entered.

I would normally do this as an IF statement, but it has to be done using conditional formatting.

Any ideas?

I'm using 2007 but have used it in 2003, too.

I'll look at that, thanks.

Tried the tutorial, thanks, though it was on 2003.

Still no better off - it's easy to format the cells on a condition, but I can't see how to enter text. Seems easier in 2003, actually.

Text isn't formatting. You'll want something like the following in the cell you want the text to appear:

=IF(A1>A2, "OK", "ORDER")

Sorry, sorry, SORRY!

Just re-read the task and there is another section later on which is obviously the conditional formatting.

Thanks so much for your help.

Snorbs got there first. It would be conditional formatting if you have a cell containing a value and you want to colour it red if it is greater than some other cell, green otherwise. To set the value, then it's a standard formula. If you then wanted to colour the OK green and the ORDER red, you'd need to use conditional formatting.

Yes, I couldn't see why it wasn't a straightforward IF statement - I was getting confused by someone's notes on the task sheet. Someone who I will be spilling coffee over tomorrow!