I am trying to use Conditional Formatting to highlight the CURRENT WEEK COLUMN in a spreadsheet. My column headings are the Friday of a series of weeks. I would like the COLUMN to be highlighted when any day of the 5 (workdays) occurs. I can get the column to highlight if I use days of the week, but not if I use WeekEnding dates.

Thanks, PM1927