Format Excel to Show and Hide different rows based on value

I have an excel file which I need to format.

If a user puts in value "1" in cell B5 then it needs to show a different set of questions in the cells below.

This needs to be repeated for "2" and "3".

So the logic will be to hide and show certain rows of excel data based on the value in the B5.

There is a total of 6 rows that need to updated based on the B5 value. i.e. 6 differenet questions based on the 3 values.

The question answers will then be sourced on the next worksheet.

Skills: Excel

See more: excel hide rows based cell value, hide excel rows based format, excel format hide value, hide excel format, excel hide show rows based value, excel hide cells user, excel show different based value, hide show cells based logic, logic hide cells, hide different excel rows based different values, hide rows certain value, show certain rows excel different worksheet, hide excel cells certain value, excel show different value, e value, show hide rows based data, excel hide cells certain value, excel show format, Value, rows, hide, format excel, excel to, DIFFERENT, sourced

About the Employer:
( 17 reviews ) Auckland, Australia

Project ID: #1151259

Awarded to:


Very Good at Excel 2003-2010 and Excel VBA Macros. Please allow me to do it. Will ensure everything is as per your requirement. I can have the solution buikt on plain formulas or also based on Excel macros if you w More

$30 USD in 0 days
(16 Reviews)

5 freelancers are bidding on average $39 for this job


>>>>>>>Experienced...>>>>>> Lets start now..

$40 USD in 1 day
(2 Reviews)

please check pmb for details

$45 USD in 1 day
(3 Reviews)

please check pm.

$50 USD in 0 days
(2 Reviews)

Hello, I offer you a complete solution. I have understood the basic idea but will ask you for clarification if needed. Regards,

$30 USD in 1 day
(0 Reviews)