Dear All

I have posted something similar but unfortunately I couldn't get the suggestions working. I have attached my vba code which I had help with as I am new to vba. What I need to do is to add criteria to when a customer spends more than 1000 (for the first part of the code) to send an email (this bit works) and at the same time the cell which has the name on (in my spread sheet is cell range B and columns 2 onwards) to change colour and if possible to start blinking (or change colour from red to white for example) .

I have attached my code below and any help will be greatly appreciated if some one can add this to me code as I am really confused.

Thanks again
Please Login or Register  to view this content.