VBA code to find the row number based on data via input box and the highlight a cell

Hello

I am a little stuck.

I have a huge data.
I want to enter a unique ID into an input box which will tell which row that id is available and then it will again ask me which column the cell needs to be highlighted. Once i enter the data, it will then ask me what is the change in data (again via input box). i can then enter the change data and then it stops.

Can any one help.

Hi,

Why dont you use a user form instead.

Look at the sample I have attached. Sample.xlsm

Thanks