Hi Guys,

I have a simple spreadsheet I use for project planning and scheduling. The jobs/tasks listed down the first column (say A4:A115) and a sequential list of work days are across the columns (C2:IS2).

I'm trying to work out how to apply conditional formatting so the column corresponding to the current date is highlighted a particular way. All the date cells are formatted as 'DATE' cells, I just can't work out how to apply a formula to them that highlights the entire column corresponding to today's date.

Any help appreciated..

Cheers