I have set conditional formating to highlight public holidays when a series of dates are calculated from a cell input for pay period week-endings. It works perfectly from a manual input, but, as I require data validation for pay period day endings and also selecting weekly paid or fortnightly paid, I have created a named list that gives a limited number of dates in the list for selection. That part works perfectly, but the conditional formatting does not work! when a selection is made from the list. So - everything works with manual input but does not work with list input. Can anybody suggest a work-around for this?