I have a two worksheet file set up that checks all cells for values in 5 different cells. If the value is found, it changes the color of the
cell. It works fine the first time I input the 5 different numbers, changing the color immediately.
The values in these 5 cells will change often, and in testing the
worksheet, at first I struggled as the colors did not change back when different values were inputted. By accident, I found that if I switched
to the other sheet and then back again, the color in fact did change.
So, it is in fact working, but I'm wondering if this is normal, and why
the color doesn't immediately change when the target does?
Thanks for any help or suggestions.
|Location:||Huddersfield, West Yorkshire, UK|
|Nodes:||16 (2 / 14)|