ho do I set up a auto alert ,at the lowest number in a list of ch.

  • Thread starter Thread starter martin jarvis
  • Start date Start date
M

martin jarvis

I have a list of staff and hours worked, I require something to highlight the
staff with the least hours worked
 
1. Select the column with the values say(col B)
2. From menu Format>Conditional Formatting>
3. For Condition1>Select 'Formula Is' and enter the below formula
=MIN(B:B)=B1
4. Click Format Button>Pattern and select your color (say Red)
5. Hit OK

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with conditionally unhiding columns 1
Construct staff pay timesheet 1
how do I set count the number of staff in a rota working per hour 1
Duplicate a set of rows for each item (subdatasheet?) 0
Help with looking up information 3
Help with workbook 4
HELP - A formula or sheet you want to move or copy contains the name .... 0
Creating a Complex Timesheet Record 1

Back
Top