PDA

View Full Version : Highlight Cell According to List and Criteria



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.

Bob Phillips
12-12-2007, 08:07 AM
1) Conditional formatting with a formula of

=SUMPRODUCT(--(EXACT($B$1:$B$7=C9)))

2) Conditional formatting with a formula of

=ISNUMBER(FIND($D$1,A1))

MachaMacha
12-12-2007, 08:16 AM
thanks XLD you always answer my questions!