ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Time Calculations and Conditional Formating (https://www.excelbanter.com/excel-worksheet-functions/233419-time-calculations-conditional-formating.html)

kristy_6278

Time Calculations and Conditional Formating
 
How can I identify if I have double booked an employee into a workshop and
Ive scheduled them at the exhibition booth? Do I use conditional
formatting?, I.e. the employee name goes red?

100 volunteers, five different types of volunteers
- Presenter
- Volunteer 1 (Speaker)
- Volunteer 2 (Administrator)
- Back up
- Personal

- 7 Sessions €“ 15 Workshops in each session
- Exhibition Booth
- *(I see 15min increments needed for the above)
--
WitkosRobinson

Eduardo

Time Calculations and Conditional Formating
 
Hi,
Take a look to Cpearson web you will find different ways to do that

http://www.cpearson.com/excel/Duplicates.aspx

If this helps please click yes, thanks

"kristy_6278" wrote:

How can I identify if I have double booked an employee into a workshop and
Ive scheduled them at the exhibition booth? Do I use conditional
formatting?, I.e. the employee name goes red?

100 volunteers, five different types of volunteers
- Presenter
- Volunteer 1 (Speaker)
- Volunteer 2 (Administrator)
- Back up
- Personal

- 7 Sessions €“ 15 Workshops in each session
- Exhibition Booth
- *(I see 15min increments needed for the above)
--
WitkosRobinson



All times are GMT +1. The time now is 08:49 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com