hi
I am a total newbie to excel but really really need help for a work project.
i have a spreadsheet with 6 columns, and loads of rows.
the 1st column (A) has questions, and the second (B) has the option to enter "N" and the 3rd(C) column is for "Y", the remaining columns will be filled with numbers.

What I am looking for is a formula (which I had before but on a version which was deleted) for, if the user enters "N" into the 2nd (B) column it will then fill across the remaining columns on that row.

thanks for the help in advance, i have spent the whole day trying to figure this out and am very close to tears.