Custom Conditional Formatting: Filling Row based on Repetion of Values in A Cell

[kpark91]

Hello,
I was trying to search up on this forum but I couldn't find anything so I apologize if there has been a question like this but I am having a problem with conditional formatting.

I want to fill entire rows that have any repeating values in column D which are in a table with 1176 rows.

I've tried using
= $D$2:$D$1176 = $D2
in the formula conditional formatting but clearly I have failed lol.

Is there any way of solving this problem just using conditional formatting?

Thank you in advance,

 

[jim may]

Select the RowHeader of rows 2:1176

then
Try using FormulaIs and in Text box enter

=COUNTIF($D$2:$D$1176,$D2)>1

Format.. Select Fill Color, then OK, OK (out)

 

[kpark91]

D: this post has one view and it's from me,,, so bump;;

 

[kpark91]

Wow, works perfectly. and there are some values which are texts... (such as "<10")

Is it possible to apply rules for that as well?
cuz it doesn't seem to be working for the texts.

Thank you so much!

 

[jim may]

It should work on duplicate numbers as well as duplicate text.

 

[kpark91]

Oh.. It works now lol ;
Thank you very much!