Conditional Formatting in Excel Table and Ignore Blanks Not Working

[LtCmdrData]

I have an Excel Table and in column D if there is a duplicate value, I want to highlight the entire row. In the Conditional Formatting Rules Manager I have the formula =Countif($D$2:$D$77,$D2)>1. This works fine in formatting the entire row when there is a duplicate in column D. However, some cells in column D are empty and it is counting and formatting those rows also. How can I modify my formula to ignore the empty or blank cells and conditionally format only the rows that have non blank or non empty cells? The data in column D is text (the letter L followed by six digits). Thank you in advance.

 

[Joe4]

Update your Conditional Formatting Formula so that it looks like this:

=AND(Countif($D$2:$D$77,$D2)>1,$D2<>"")

 

[LtCmdrData]

That worked perfectly. Thank you very much sir!

 

[Joe4]

You are welcome.
Glad I was able to help!