sum & count colored cells automatically when colored cells change

  • hello

    i have data in sheet1 and i have two function one to sum colored cells and the other counting colored cells and i have code in event worksheets change it color the cells based on conditions all of them don't work well the problem when change color from a2:e it doesn't change automatically when sum and count colored in column h, i, i have to press any cell and move another cell then happens changes , i would directly change the values in column h,i when change colored cell

    this is my code in worksheets change event works but not as what i want

    note : way filling data should write numbers in column a 10 or 15 then color the rest columns

    i crossed post in this forum

    https://www.mrexcel.com/board/…nge.1132747/#post-5479093

    no body answers me so far

  • HI