Conditional Formatting

  • Thread starter Alastair Brannen
  • Start date
A

Alastair Brannen

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.
 
J

JE McGimpsey

One way:

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

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