Conditional formatting based on criteria

Hi,
I've created a spreadsheet to track little league pitch counts and mandatory days rest, but would like to automate it with conditional formatting on a calendar grid.

So far, I've included a list of players, separately the criteria for days rest (this works by pitch counts, so for instance if a kid throws between 21 and 35 pitches, he needs one day rest before he can pitch again), a table to enter the pitcher/date/pitch count and a calendar grid with a formula which shows the day a pitcher threw and the number of pitches.

What I am trying to do, is have the calendar grid automatically (with conditional formatting) gray out the days when the kid cannot pitch (i.e. the days rest they need before they can pitch again).

I can't figure that last part out. Let me know if you can help. Thanks.

Frank

@Melvinrobb, yes case in point why I want the conditional formatting (gray shading) to be automated based on the input from the table - to avoid making mistakes in the shading.

So the key would be to reference the cell with the number of pitches (or the table itself - not sure what is the better way to do it) and have a formula (in the conditional formatting tool - not sure?) so that the shading results automatically after the entry is made in the table.

Thus, a one-time entry into the table (pitcher name, date, pitches thrown) and the formula(s) fill in the calendar grid with pitch count (on day thrown) and gray out the days the pitcher cannot pitch.

Thank you @newdoverman - looks like this version did the trick. I will tool around with it and get back if I have any questions - thanks again!

@newdoverman, I combined my initial worksheet and your worksheet for the final product - see attached. Thanks again!