Forum Discussion
Limiting the number of times an initial appears in a week to 3
Select C6.
On the Home tab of the ribbon, click Conditional Formatting > Manage Rules...
Select the rule and click Edit...
Change the formula to
=COUNTIF($C$6:$F$100,C6)<=3
Thanks for the quick reply!
It kinda works but there are some loopholes
For example, if you look at the row for Desk 2 and 3, I can input the person AP more than 3 times if I put their initials for day 1-3 in desk 3 and day 4 in desk 2.
If i try to put the person AP for day 1-4 in desk 3, the error pops up which is good.
But is there a way to prevent this issue?
Thanks for your help
Select C6.
On the Home tab of the ribbon, click Conditional Formatting > Manage Rules...
Select the rule and click Edit...
Change the formula to
=COUNTIF($C$6:$F$100,C6)<=3
thank you so much!
im currently working as an intern and being able to do this properly is a great help.
hope you have a good day! i appreciate it