View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
hospitalgreg hospitalgreg is offline
external usenet poster
 
Posts: 1
Default If Then Question from Newbie. . .

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.