When 5 is entered 5 Boxes Appear

  • Thread starter Thread starter cassy01
  • Start date Start date
C

cassy01

Is It Possible so that When I Enter a number in Cell C5

5 boxes become formatted in yellow in cells C6:C10 (and also unlocke
if possible)

and then when i enter 7 in C5, 7 boxes appear ??

many thanks
Ben
 
Hi
try the following:
- select cells C6:C20
- goto format - conditional formating
- enter the following formula:
=ROW(C5)-4<=$C$5
- choose a pattern for this condition

note: This only changes the formating. If you also need to change the
lock property you'll need VBA
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

@Need help with a formula 8
Last Modified By in a cell by user 3
Transpose between sheets 4
Formula Help 5
Where to put quotes in a SUMIF formula and when is & used for cell 2
Conditional Format over Date Range 3
Getting what cell the text is in 2
Need a function 1

Back
Top