sticks
unread,Jan 12, 2023, 1:09:52 PM1/12/23You do not have permission to delete messages in this group
Sign in to report message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to
Hello,
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.
sticks