Hi,
This is subsequent to a previous post and am posting a new thread for this question. I have a workbook that autofills rows based on start and end dates and joins events associated to that date. The formula permits only workdays, and no weekends and holidays. However, there are some blocked dates, and I am looking for all the cells that have any format of the blocked date to be highlighted (ddd, mmm dd, 'yy) or dddd, mmmm dd, yyyy, etc) to be highlighted. I tried conditional formatting, but it only highlights one column and in the full format. I've attached a sample workbook.
Any suggestions?
Thanks.
Bookmarks