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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top