Hello all,

Below is an example of what is in my worksheet. I am trying to limit the number of issues I can work on a day if the difficulty level adds up to 5 or is 5.

Issues Difficulty Date
Create inv. macro 5 1/20/2014
Call UPS 1 1/20/2014
Pick up package 4 1/21/2014

I would like to use a custom data validation in column B to help me limit the number of issues I can work on based on the difficulty level. Using my example worksheet above, if my issue is "Create inv. macro" and the difficulty level is 5 then the date I entered to work on it(i.e 1/20/2014) should be the one day I can't work on something else. And I would like there to be warning preventing me from doing so.