Coloured cells based on formula
 

No doubt this has been covered previously.

I want to apply an IF formula, where by the whole cell changes to RED if the
result is less than say 5%, or GREEN if it's 5% or above.

How do I do this? I'm using Excel 97.

Thanks in advance. Steve.

You need Conditional Formatting. Look at 'Highlight cells that meet specific
conditions' in the Answer wizard

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Steve Elliott" wrote in message
...
No doubt this has been covered previously.

I want to apply an IF formula, where by the whole cell changes to RED if
the
result is less than say 5%, or GREEN if it's 5% or above.

How do I do this? I'm using Excel 97.

Thanks in advance. Steve.