Help Needed

[bnageshrao]

In have a spreadsheet which has about 1000 lines. I want to achieve the following and let me know whether it can be achieved, if so please help me.
After inputting the data user will click a validate button which should check from row 1 to 1000 and if any one column in a perticular row is filled then it should highlight all the remaining blank fields in that row. If a row is blank then it should ignore that row. Now user knows which field are blank by looking at the highlighted cells and types it in the required values. When he types it the color should go back to the original color. Any help is greatly appreciated. Thanks in advance.

 

[DarkSun]

How many columns are there? Have they got headers?

 

[bnageshrao]

Thanks for trying to help, I did something and now it works. LOng time ago I put a button in one of the vb project and when user tried to click it, it keeps on moving(mainly it is for fun).Do you remember the code to do that, if so please send me