Conditional Formatting
 

I have a column which contains the date of every Monday. I would like the
Monday of this week to be highlighted. Any assistance would be greatly
appreciated.

One way:

Select your column and replace A1 with your ActiveCell if necessary:

CF1: Formula is =WEEKDAY(A1)=2
Format1: Pattern/<highlight color




In article ,
"Alastair Brannen" <Alastair wrote:

I have a column which contains the date of every Monday. I would like the
Monday of this week to be highlighted. Any assistance would be greatly
appreciated.