Conditional Formatting to highlight consecutive dates?

Good evening everyone,

I am a newbie on this forum, but I suspect you will be seeing me on here a few more times, after I have checked the sub-forums first

I have to produce a report showing names, dates and lots of other private information. What I need to do is sort by name, then date - simple enough. Then I need to highlight if there are 3 or more consecutive dates for each individual person.

As I am new to Excel it is slightly confusing, but I am learning, albeit slowly.

I have attached a screenshot which will explain it better.

Three or more consecutive dates need to be highlighted, this report will need to be printed off each week and checked so would make it easier to see.

screenshot.jpg

If anyone could point me in the right direction it would very much be appreciated.

Thank you everyone

Welcome.

You need to have two empty rows before your data.

Select the Area That you want highlighted.

Select the home Tab and then Conditional formatting

Select Manage Rules and then New Rule

Select Use Formula to choose which cells to format.

Paste this formula into the formula box.

=OR(AND($A3 <> "",$A2=$A3,$A3=$A4),AND($A4<>"",$A3=$A4,$A4=$A5),AND($A2<>"",$A1=$A2,$A2=$A3))

Select the Format Button and select you fill colour.

Click on ok three times to exit.

Helper column C is used.
ARRAY formula in C2 then dragged down.

=IF(AND(COUNTIF($A$2:$A$23,$A2)>=3,OR(AND($A2=$A1,$B2=SUM($B1)+1),AND($A2=$A3,$B2=$B3-1))),LARGE(IF($A$1:$A1=$A2,$C$1:$C1,0),1)+1,"")

How ARRAY formula is entered

Paste Formula in the cell.
Press F2
Hold Shift+ Ctrl Keys and hit Enter key.
Now the formula is surrounded by {} by excel.