# restricted excel rules

#### gomaa1239

##### New Member
Dears,

im trying to make an excel sheet to organize the vacations of my small team, and i dont know how to do the following and i will be so happy of you could help me this time like what you always do

the sheet will be like below
1st column will include the whole days of the year and we can give a maximum number of 3 days as a vacation for each employee so i need a rule to allow each user to put letter (v) _stand for vacation_ only 3 times in his column per each month
if the employee tried to insert the (V) for the 4th time per month he should get an error

 date name1 name2 name3

<tbody>
</tbody>
1/10 v
2/10 v
3/10 v
4/10 v
5/10 v
6/10 v

2) i need to know how to enable excel cell range editing by certin user

### Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

#### KenDue

##### New Member
One idea to get you started: With dates in column A, at the end of each month's rows, place a Total Vac row with the formula =COUNTIF(B3:B32,"v") or whatever number of rows covers the range for that month beneath the first employee's daily cells. Place this conditional format formula =B33>3 in that same cell and format the color of the cell "Red" when condition is met.

Copy the formula across the columns for each employee.

Follow the same procedure for each month.

Hopefully, someone else has an idea for your second need regarding restrictive cell range editing.

#### FDibbins

##### Well-known Member
For the 1st part, you could use Data Validation, find it under DATA tab/data Validation, and put something like this in the CUSTOM option...
=COUNTIF(\$B\$2:\$B\$7,"v")<=3

for the 2nd part - why would you need anyone to adjust ranges?

Replies
0
Views
155
Replies
2
Views
289
Replies
0
Views
266
Replies
6
Views
1K
Replies
3
Views
198

1,191,116
Messages
5,984,735
Members
439,905
Latest member
VBAhelpplz

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back