automatically send email if cell background colour changes

    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

    Re: automatically send email if cell background colour changes


    If you query the background colour of a cell coloured with Conditional formatting, Excel will report the actual background colour, not the colour applied by the conditional formatting. And conditional formatting does not raise any events when a conditional colour is applied.


    There are ways around this, but they involve a lot of code - see here for examples.


    You may want to reconsider the trigger for the emails.

    Re: automatically send email if cell background colour changes


    HI.. I am wondering if this would work (based on cytops comments)..


    Perhaps make it so that any cell that has red color also has a alpha/numeric text value (lets say x)..


    Make the text value be the same color as your cell fill color (so it will be invisible)..


    Then.. base your event on the Selection Change event and then send your email ( google is your best friend.. type this into google ... excel + email + vba )

    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

    Re: automatically send email if cell background colour changes


    I'm so sorry I didn't give a 'proper' answer to your question...!


    It seems the quality of replies is directly related to the cost of asking questions.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login