I'm trying to create a payroll calendar. We get paid twice a month, on the 15th and the last day of the month but never on a weekend. If the 15th or the last day falls on a weekend payday gets shifted to the preceding Friday.

How would you write a conditional formatting function to shade the payday cells red and do it for the entire year? The data set is the dates of a full year calendar on one worksheet. I'm using Excel 2016.

I'm trying to create a payroll calendar. We get paid twice a month, on the 15th and the last day of the month, but never on a weekend or Good Friday. If the 15th or the last day falls on a weekend, payday gets shifted to the preceding Friday. If the 15th or the last day falls on Good Friday, payday gets shifted to the preceding Thursday.

How would you write a conditional formatting function to shade the payday cells red and do it for the entire year? The data set is the dates of a full year calendar on one worksheet. I'm using Excel 2016.

I'm trying to create a payroll calendar. We get paid on the 15th of the month and the last day of the month unless that day falls on a weekend, then we would get paid on Friday.

How would you write a conditional formatting function to shade the payday cells red and do it for the entire year? The data set is the dates of a full year calendar on one worksheet.

I'm trying to create a payroll calendar. We get paid twice a month, on the 15th and the last day of the month but never on a weekend. If the 15th or the last day falls on a weekend payday gets shifted to the preceding Friday.

How would you write a conditional formatting function to shade the payday cells red and do it for the entire year? The data set is the dates of a full year calendar on one worksheet. I'm using Excel 2016.

I'm trying to create a pay role calendar. We get paid on the 15th of the month or the last day of the month unless that day falls on a weekend, then we would get paid on Friday.

How would you write a conditional formatting function to shade the payday cells red and do it for the entire year? The data set is the dates of a full year calendar on one worksheet.

I'm trying to create a payroll calendar. We get paid on the 15th of the month and the last day of the month unless that day falls on a weekend, then we would get paid on Friday.

How would you write a conditional formatting function to shade the payday cells red and do it for the entire year? The data set is the dates of a full year calendar on one worksheet.