Conditional Formatting to exclude weekends

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

Hi! What the worksheet should be able to do is if today is Monday, the Friday column should be Highlighted in maroon with a bold white font. This tells us that we need to input Friday's data in Friday's column. If today is Tuesday (August 13), then yesterdays Monday's column should be highlighted. So far my conditioning format is working on any day but Monday.

Thanks!

Originally Posted by daddylonglegs

What condition are you using now? If you want to format a cell when A1 is the previous working day try using WORKDAY function in a conditional formatting formula, e.g.

=A1=WORKDAY(TODAY(),-1)

Hi! I'm using Dates Occuring and Yesterday. Pls see attached doc. 8/11/2013 is highlighted instead of Friday 8/9/2013. Basically, the previous workday should be highlighted, excluding weekends.

I did try your suggestion but didn't work.

Thank you!

Thanks! I really appreciate your help.