What you want is called Conditional Formatting. Take a look here for
some good stuff on Conditional Formatting.

http://www.cpearson.com/excel/cformatting.htm


hospitalgreg wrote:
I have the following basic spreadsheet set up:

A B C D E F
G
1 Service Jan Feb Mar Total
Avg
2 Orthopedics 52 28 60 140 47

I would like the monthly figures (C2, C3, C4) to turn red if they are 20%
below the running Avg (G2). I am entering the monthy numbers directly. Any
suggestions would be greatly appreciated.

Thanks in advance.