Highlight entire row based on text in specific cell

[sameeruddin1001]

I have my data in excel from A11 : R1021 of sheet1, if I give a six or seven digit number (EX: 123456) in cell B1 and press ENTER KEY the Excel should automatically find that number from the data range mentioned above (i.e. A11 : R1021) and highlight the entire row (for ex: if the number is located in cell D99, then excel should automatically highlight the entire row from A99 : R99)

Please help me with a VB macro for this.

 

[Joe4]

Have you seen Post#3 bottom linws?

Ah, sorry. I missed that.
They seem to be jumping around a bit.
My apologies.

 

[mohadin]

No problem
Be happy & safe

 

[navic]

Perhaps, another way by formula (Conditional Formatting in range $A$12:$R$16)

=SEARCH(TEXT($B$1,0),$D12)
or
=SEARCH(TEXT($B$1,0),$A12&"-"&$B12&"-"&$C12&"-"&$D12&"-"&$E12&"-"&$F12&"-"&$G12&"-"&$H12&"-"&$I12&"-"&$J12&"-"&K12&"-"&L12&"-"&$M12&"-"&$N12&"-"&$O12&"-"&$P12&"-"&$Q12&"-"&$R12&"-")