Good morning!

I have a worksheet of each month, column for each day. If today is Monday, we want to enter data for the previous business day. In this case, it will be Friday. I would like to have Friday's date (entire column if possible) to be highlighted in white bold font with maroon fill-in. So, whoever needs to enter Friday's data would know right away when he/she opens up document which column to work on. It works Monday - Thursday but not for Friday. Thanks!

8/1/2013 8/2/2013 8/5/2013
Thursday Friday Monday
Total English-Speaking Staff 64 64 64
Vacation Scheduled (hours) 45.50 80.00 56.00
Vacation Unscheduled (hours) 24.50 0.00 0.00
Sick Leave Scheduled (hours) 37.50 35.00 25.00
Sick Leave Unscheduled (hours) 73.00 69.25 33.75
Training Scheduled (hours) 45.00 0.00 0.00
Training Unscheduled (hours) 0.00 0.00 0.00
Meeting Scheduled (hours) 0.00 0.00 0.00
Meeting Unscheduled (hours) 0.00 0.00 0.00
Other Scheduled (hours) 45.00 44.00 44.00
Other Unscheduled (hours) 0.00 0.00 0.00
Total Leave Hours English 270.50 228.25 158.75
Staff Leave Equivalent 33.81 28.53 19.84
Total English-Speaking Staff Available 30.19 35.47 44.16