| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
ho do I set up a auto alert ,at the lowest number in a list of ch.
I have a list of staff and hours worked, I require something to highlight the
staff with the least hours worked |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
ho do I set up a auto alert ,at the lowest number in a list of ch.
1. Select the column with the values say(col B)
2. From menu FormatConditional Formatting 3. For Condition1Select 'Formula Is' and enter the below formula =MIN(B:B)=B1 4. Click Format ButtonPattern and select your color (say Red) 5. Hit OK If this post helps click Yes --------------- Jacob Skaria "martin jarvis" wrote: I have a list of staff and hours worked, I require something to highlight the staff with the least hours worked |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you auto-number a large list of rows in Excel? | Excel Discussion (Misc queries) | |||
| Auto number for a parts list. | Excel Discussion (Misc queries) | |||
| determine lowest number in several columns and replace lowest numb | Excel Worksheet Functions | |||
| can excel alert you when a number is less than a particular value | Excel Worksheet Functions | |||
| Lowest number | Excel Worksheet Functions | |||
Linear Mode
