Conditional Formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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>
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Excel VBA Script help 0
How to format cell to get first capital letter? 5
calculate a date, 10 weeks after a set date & return a specific da 2
need help writing function 9
Adding Days 2
Formula for counting more than one criteria 1
Conditional Formatting Assistance 4
Convert Month, Week, Year to date 2

Back
Top