how to display remaining rows as blanks
 

Hi, I would be very thankfull if anybody could help me with the following:

This is a simulation problem. According to a random generated number (using
the RAND() and the nested IF functions) the number of customers can be 10,
14, 18, 22.
I have a single worksheet of 22 customers (cell D4:D25). If # of customers
generated (in cell C4) is 10 how can I make it display only the first 10 rows
(customer 1 to 10 , D4:D13) and the remaining rows (11-22, D14:D25) to be
displayed as blanks. same goes for 14, 18 and 22 customers.

Thank you

Have a macro change the font to white for the row you dont want to see.
HTH,
--
Gary Brown

If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"Demetrios13" wrote:

Hi, I would be very thankfull if anybody could help me with the following:

This is a simulation problem. According to a random generated number (using
the RAND() and the nested IF functions) the number of customers can be 10,
14, 18, 22.
I have a single worksheet of 22 customers (cell D4:D25). If # of customers
generated (in cell C4) is 10 how can I make it display only the first 10 rows
(customer 1 to 10 , D4:D13) and the remaining rows (11-22, D14:D25) to be
displayed as blanks. same goes for 14, 18 and 22 customers.

Thank you

Thanks for your answer, how can I make the macro to do that, I have no idea
how to create macros


"Gary L Brown" wrote:

Have a macro change the font to white for the row you dont want to see.
HTH,
--
Gary Brown

If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"Demetrios13" wrote:

Hi, I would be very thankfull if anybody could help me with the following:

This is a simulation problem. According to a random generated number (using
the RAND() and the nested IF functions) the number of customers can be 10,
14, 18, 22.
I have a single worksheet of 22 customers (cell D4:D25). If # of customers
generated (in cell C4) is 10 how can I make it display only the first 10 rows
(customer 1 to 10 , D4:D13) and the remaining rows (11-22, D14:D25) to be
displayed as blanks. same goes for 14, 18 and 22 customers.

Thank you

Use conditional formatting. Highlight cells D4:D25, then use the Format menu
to select Conditional formatting... Select Formula is and use

=(row()-4)$c$4, then click on the Format button and set the Font color to
white


Be aware that the values are still there and they will show up in the
formula bar. This simply changes the font color to match the background so
that the values will not display, despite their presence

"Demetrios13" wrote:

Hi, I would be very thankfull if anybody could help me with the following:

This is a simulation problem. According to a random generated number (using
the RAND() and the nested IF functions) the number of customers can be 10,
14, 18, 22.
I have a single worksheet of 22 customers (cell D4:D25). If # of customers
generated (in cell C4) is 10 how can I make it display only the first 10 rows
(customer 1 to 10 , D4:D13) and the remaining rows (11-22, D14:D25) to be
displayed as blanks. same goes for 14, 18 and 22 customers.

Thank you