Highlight current week column

**podge** · 04-06-2010, 10:22 AM

Hello,

I have a workbook which I use to plot financial project milestones. The columns along the top have the date range in weeks i.e. [ 01-mar ]....[08-mar] and so on, the rows below the projects and the values. I would like to highlight the current week column, I can do this manually but as the weeks go by I have to re-do the original formatting every time (annoying).

Does anyone know of a more intellegent way of highlighting the "current week" column?

Thanks in advance for your time,

Podge

**rwgrietveld** · 04-06-2010, 10:25 AM

The important part here is the format of:

[ 01-mar ]....[08-mar]

One could check and have a Cond. Formatting accordingly.

Please specify the avobe format (e.g text, dates, ...)

Are this two cells or one cell?

**deemo** · 04-06-2010, 10:29 AM

If you had

A1: 29-Mar
A2: 05-Apr
A3: 12-Apr

then you could enter a conditional formatting formula

=AND(TODAY()>=A1,TODAY()<B1)

which would highlight the week you are currently in