Re: automatically send email if cell background colour changes
hi cytop i didnt get proper answer of my question...
if it is not possible to send cell coloured with conditional formatting then is there a way to send the 'quality" sheet as jpg format or any other format so that the sheet can be send as it is...
please help me out
i have made a Workbook named "Audit Sheet (Autosaved).xlsm" in which one sheet named "Quality". In Quality Sheet there are some conditional formatting..
Now i want that if in that sheet from Column X to Column AW any cell background becomes red in colour than i should get automatically an email of that quality sheet attached in two address say - 1. "[email protected]"[/email] and 2. "[email protected]"[/email].
please help me out of this problem as soon as possible
thanks in advance
