Hi!

I am looking for a way to have a list created based on the value inserted in
a cell.

Example: the value "X" to be inserted in cell A1 contains the number of
people. Based on this value I want a list with the rows numbered from 1 to X
(number of people). I also want the cells of the list to have a certain
colour and the list to be framed with a black border. If the value in cell A1
is changed, the number of cells to have this particular colour and the border
should change accordingly.

I will be very thankful for any tips on which functions I should use and
what I should look up to create the above result!