| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I apply conditional formatting to people who are below aver
Please help
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I apply conditional formatting to people who are below aver
Use the white space (not subject line) to ask the question
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Ken321" wrote in message ... Please help |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I apply conditional formatting to people who are below aver
Let's say we have names in column A from A1 thru A30. In column B we have a
score for each name. The scores could be height or weight or white cell count or anything else. Set the condtional format in A1 to Formula is: =B1<AVERAGE(B$1:B$30) with a distinctive background. All the names with scores below average will be hi-lighted. -- Gary's Student "Ken321" wrote: Please help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting similar to shading alternating rows | Excel Worksheet Functions | |||
| Conditional formatting using lookup | Excel Discussion (Misc queries) | |||
| Conditional Formatting: "handwritten" circles? | Excel Discussion (Misc queries) | |||
| Conditional Formatting Cell < Today() | Excel Worksheet Functions | |||
| Effect of Conditional Formatting, Data Validation | Excel Discussion (Misc queries) | |||
Linear Mode
