If Statement &Cell Colour

[RIVIERA]

I want excel to colour a cell if the statement below is true & another colour if false. Any help greatly appreciated.

=IF (G10<E10,"ALARM","OK")
This message was edited by RIVIERA on 2002-10-25 10:22

 

[lenze]

welcome to the board.

Your post did not come through. Edit it and select the "disable html on this post" option

 

[Von Pookie]

You can just use Conditional Formatting

Go to Format|Conditional formatting and then set your criteria.

Hope it helps,