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

P

Peter

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!
 
C

Cutter

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
 
P

Peter

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