Help with excel notifications.

**labaker_05** · 08-13-2014, 12:49 PM

Hi there, I hope someone can help me and can explain in really simple terms as I am not great with excel at all.

I have a spreadsheet that contains all of our staff members (around 50 going down the "a" column) and the mandatory training that they must complete (10 subjects going across the top). They are a couple of things that I want to do with this sheet but I have no idea how to do this.

1) I want the dates in which people's training expires to change colour to blue, those that is about to expire in a month to go green.

2) Copy the names and their training required onto another worksheet so I can keep a list of who I need to arrange training for. Rather than looking down each column and hand writing the names out.

I also want to know is it possible for the sheet to then email me people who's training has expired or is about too?

Example.
Fire safety First aid. Manual handling
John. 12/04/15. 23/08/15. 04/05/15
Frank. 14/05/15. 16/07/15. 08/08/15
Julie. 21/11/15. 11/02/15. 22/10/15
Sharon. 03/04/15. 07/06/15. 12/04/15

Many thanks in advance.

**Pepe Le Mokko** · 08-13-2014, 12:52 PM

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

**labaker_05** · 08-20-2014, 03:40 PM

Hi there,

I have managed to put in some conditional formatting which changes the colour of the cells after reading other posts on this website.

I now would like to know if this is possible... Lists to be created from the cells that change colour. I have done this with a before and after sheets, however for my workbook i would like the lists create onto a different page not on the same one. I have attached the file to show you.

NEW OVERVIEW altered.xlsm

Thanks in advance.