Highlight entire row

M

Mandeep Dhami

Hi,

I have a series of data alphanumeric in various columns from A2 to I125
(aaprox.). The same has many rows.
I want that in cell B1 when I enter certain data (either numeric or
alphanumeric or just words) the same should search in the data below (from A2
to I125) and highlight the rows (or the rows gets filled with certain
colours) which has that data entered in B1.

Cheers,
Mandeep
 
M

Mandeep Dhami

Thanks Max for the reply.
But sorry to say the result is not as per expected.
With the formula given by you, all the rows gets coloured and when I enter
data in B1 all the rows get back to normal i.e., without any colour.
What I wanted is that the formula should work as Find option, where in the
entire database should be searched and where ever the data is matched with
that entered in B1 the entire row should get highlighted.
If the formula does not work then can the MACRO be written for the same. If
yes, could you help with the same.

Cheers,
Mandeep
 
Top