excel 97.How do I change text colour in A1 if A2 is >4?!!

Hi,
I'm using Excel 97 (yes ...I know...!) and I'm trying to format the text in
a cell say A1 depending on the value contained in a different cell! eg turn
the text red in A1 if value in A2 is > 4.

Many thanks!

Click on A1
Select Format > Conditional Formatting
Click on drop down on left side and choose "Formula is"
In area immediately to right type: =A2>4
Click on Format button
On the Font tab click on the Color button and choose red from the palette
Click OK
Then click OK

Thanks very much Cutter...Never used the 'formula is' conditional function.
You've saved me a lot of time!
Cheers

"Cutter" wrote:

>
> Click on A1
> Select Format > Conditional Formatting
> Click on drop down on left side and choose "Formula is"
> In area immediately to right type: =A2>4
> Click on Format button
> On the Font tab click on the Color button and choose red from the
> palette
> Click OK
> Then click OK
>
>
> --
> Cutter
> ------------------------------------------------------------------------
> Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
> View this thread: http://www.excelforum.com/showthread...hreadid=519779
>
>

You're quite welcome Peter.
Thanks for letting us know you got it working.