hi,

I have the days of the month (Just weekdays) in col B with the first date starting in B2.

I'm looking for a formula or a way using conditional formmating to highlight yesterday, the problem I find is when its a monday I want it to highlight the last entry which would be a friday because I'm excluding weekends. I also want it to highlight the full row in the table so from A-H.

Any ideas

Thanks