Hi Guys,
I am new member and I hope i will find a solution to the problem which i have.
The point is:
I set my cell to flash based on conditions from another cell and it does work until a certain point when an error occurs
"Method Range of object worksheet failed Procedure Worksheet Change".
I have attached a file.
I will try to explain what the problem is.
When I start filling in the blanks cells below the cell named "plan",
if the condition I set matches, the cells in defined range start blinking,
but when I continue to fill in the cells at one point the error I wrote above appears.
The cells stop blinking and I cannot fill the remaining empty cells.
When you open the file please enter for example number 2 in cell q25 and you will see what the issue is
What im tryaing to do is to set a cell to blink in red if the percentage obtained by dividing the stock and plan is less than 25%.Hope someone will help me to solve this problem
Thanks,
Losmi
Bookmarks