how to display remaining rows as blanks

[Guest]

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 D425). If # of customers
generated (in cell C4) is 10 how can I make it display only the first 10 rows
(customer 1 to 10 , D413) and the remaining rows (11-22, D1425) to be
displayed as blanks. same goes for 14, 18 and 22 customers.

Thank you

 

[Guest]

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

 

[Guest]

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

 

[Guest]

Use conditional formatting. Highlight cells D425, 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