Hello again,
I have a work schedule sheet set up with a summary line at the top of the page. This line contains totals for priority codes, for example cell N3 has a formula to search and return the total number of times "DC" is found in range M9:M306. In this case there are 19 occurances. Is there a way to click on the cell (N3) that contains the total and then have the 19 different rows highlight or flash.
I have a work schedule sheet set up with a summary line at the top of the page. This line contains totals for priority codes, for example cell N3 has a formula to search and return the total number of times "DC" is found in range M9:M306. In this case there are 19 occurances. Is there a way to click on the cell (N3) that contains the total and then have the 19 different rows highlight or flash.