Excel 2007 : Highlight current week column

**pm1927** · 01-25-2011, 07:55 PM

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

**MarvinP** · 01-25-2011, 08:35 PM

Hi pm1927 and welcome to the forum,

A small example of what your data looks like would help with a prompt and accurate answer. Click on the green Edit button below your original post, then on the "Go Advanced" and then on the PaperClip Icon to upload a short example Exel file.

**Cutter** · 01-25-2011, 08:51 PM

I'm thinking it might be:

With your entire range of Friday dates selected use this as the formula for CF

=AND(A1>TODAY()-1,A1<TODAY()+5)

replace the A1 refs with the first cell address in the range