Complex Conditional Formatting formula help

Sorry.. This maybe:

=AND(COUNTIF($A$1:$A1, $A2), COUNTIF($B$1:$B1, $B2))

Yes.. Higlight 2nd and every other order.. In another name: duplicates...

I guess I wasn't focused.

Try this:

Select columns A and B then apply conditional formatting with this formula

=($A1=MIN(IF($B$1:$B$1000=$B1,$A$1:$A$1000)))*($A1<>"")

This will work for data down to row 1000, adjust as required

Yes, this part....

=MIN(IF($B$1:$B$1000=$B1,$A$1:$A$1000))

finds the smallest date associated with the ID in B1. If A1 is that date (or one of those dates), it'll be highlighted. As you want to highlight both columns all the column letters have preceding $ signs so that the formula doesn't change from column A to B......also we don't want the ranges A1:A1000 and B1:B1000 to change, the only part that should is the $B1, no $ sign before the row number because that should change down the column to compare against the specific ID for each row.

When I tested I realised that my initial formula would also highlight blank rows so I added the ($A1<>"") part to prevent that. Some people prefer to use AND, i.e.

=AND($A1=MIN(IF($B$1:$B$1000=$B1,$A$1:$A$1000)),$A1<>"")

That will work just the same

Sorry, yes, I didn't say that explicitly.

With conditional formatting you need to remember that the formula given applies to the top left cell in the range selected (in this case A1) and that the formula will adjust for each cell in the range the same way it would if you put it in a cell and copied it down the column. In this case then B1 will have the same formula as A1 but A2 will change to

=($A2=MIN(IF($B$1:$B$1000=$B2,$A$1:$A$1000)))*($A2<>"")

...and the same way all the way down the column....

One more question for you, which might be harder, not sure. I was hoping to find customers that have more than one order, or in other words, more than one OrderDate.

Right now, I know i have to use frequency in a third part of the AND statement, but can't figure out how to pull and count frequency of only the date range of the customer, and not the whole date range.

I also only wanted to do this for the values we had already checked, so I did this:

=AND($A1=MIN(IF($B$1:$B$48050=$B1,$A$1:$A$48050)),$A1<>"",IF(1=IF($B$1:$B$48050=$B1,1),IF(FREQUENCY($A1: )>1,1))

And you can see where I'm stuck inside the Frequency formula. I know I need relative values, but not sure if this is possible.

So you still want to highlight the first order for each customer......but only if there are subsequent orders for that customer? Try like this

=AND($A1=MIN(IF($B$1:$B$1000=$B1,$A$1:$A$1000)),SUM(($B$1:$B$1000=$B1)*($A$1:$A$1000<>$A1))>0)