As far as I can tell, your CF is working correctly. I think you may have a misunderstanding about what I meant by sequencing the formats.

This is not always necessary and I only made mention of it because your data showed two difference codes for the same date for Jason. Based on what I can tell about your workbook, this was probably an error because he will not have a vacation day and free day on the same date - it will be one or the other.

If you are, in fact, having an issue, then be specific about your "lack of success" so that we can pinpoint where the help is needed.