| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| newbie question | Excel Worksheet Functions | |||
| Newbie With A Question | Excel Worksheet Functions | |||
| Newbie question: Matching data/2 wkshts copying info over | Excel Worksheet Functions | |||
| Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
| Newbie to charts question - projecting values between data points | Excel Discussion (Misc queries) | |||
Threaded Mode
