Account search | General Excel Questions & Answers | Excel Forum

Hi,Expert

i Need your help if i input account number in sheet 2 in any cell,it will hilight cell in column A in sheet1.i use SEARCH in conditional formating it works but only one account.in sheet2 if i put another account below the previous account it will not hilight the new, it hilights only the prev account.

how is it possible to do this?

thanks

note:i use this to keep track of account i have verified.