Clever Geek Handbook

How do I highlight dates in a specified range?

I have one column ( A

) of dates in Excel, each row of which represents one day in a year. I want to highlight a date if it is included in the list of dates ( $C$3:$C$28

) on the same page.

I want the date to be highlighted if it was a due date that happens every second Friday (every Friday). I don't want to manually go through and select them piece by piece.

I tried to conditionally format the range by going to Conditional Formatting> Highlight Cell Rules> Equal to and specifying $ C $ 3: $ C $ 28. This obviously doesn't work.

Is there a conditional formatting formula I can hook into to highlight the due dates in my data range? Or is there a macro that I can use?

+3


source to share


2 answers


CF formula rule:

=AND(WEEKDAY(A1)=6,MOD(COUNT(A$1:A1),2))

should work any other Friday.



For other Fridays of the above:

=AND(WEEKDAY(A1)=6,NOT(MOD(COUNT(A$1:A1),2)))
0


source


How about: "Conditional Formatting"> "Highlight Cell Rules"> "Duplicate Cell Values" and select all columns A and $ C $ 3: $ C $ 28



It will highlight both columns A and C, but it will highlight A.

0


source






More articles:


All Articles