Coloured cells based on formula

S

Steve Elliott

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.
 
B

Bob Phillips

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