MachaMacha
12-12-2007, 07:25 AM
I have two requests that are very similar.
Request 1
Please see the attached jpeg
I have a list of Strings in B1:B7
I want the macro to look through column C for any matching strings and highlight the corresponding rows.
The list of strings to find can expand in the future, and the conditional formatting should be case sensitive
Request 2
In cell C1 I write a string or value I am searching for
The macro looks through column A for string with the value in C1 and highlights those rows.:help
Thanks.
Request 1
Please see the attached jpeg
I have a list of Strings in B1:B7
I want the macro to look through column C for any matching strings and highlight the corresponding rows.
The list of strings to find can expand in the future, and the conditional formatting should be case sensitive
Request 2
In cell C1 I write a string or value I am searching for
The macro looks through column A for string with the value in C1 and highlights those rows.:help
Thanks.