When 5 is entered 5 Boxes Appear

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
 
F

Frank Kabel

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
 
Top