Take a look at Format|Conditional formatting.

You get to specify up to 3 conditions--so it sounds perfect for you.

Pat Watson wrote:
>
> I have a budget calculator to return a value Good Bad or OK dependent on
> status based upon
> =IF(B109>B108,"GOOD",IF(B109<B108,"BAD",IF(B109=B108,"OK")))
>
> What I am looking to do in addition to this would be set the cell colour to
> red green or blue according to the status how could I do this?
>
> Any help appreciated.

--

Dave Peterson