I have a sheet that is basically a calendar. Different people can access and select Vacation (V) days, or Floating Holidays (FH), or Carry over Vacation (CV) in cells lined up on a row by their name. Each Employee has differing amounts of each type of time. I have conditional formatting for these cells that change background color based on whether it is a Saturday or Sunday and also if it is a Holliday. I am using 2 conditional formats for this. I have a cell for each category that counts down to 0 from the total # of each type days they have remaining in each category. I have data validation turned on for the cells which only allow input from a list equal to "V"," CV", or "PH". I would like to not allow "V" as an input to the cells when the Days Remaining for that category is = to 0. Or "CV" as an input to the cells when the Days Remaining for that category is = to 0 etc. I would prefer not to use VBA if Possible. My thoughts was to use an if statement in the Data Validation as a formula along with requiring an Upper Case "V", "CV, "PH" but actually formulating a formula that will work has eluded me. Sorry for the wordy request Thanks in Advance Frank