conditional formatting

[Excel beginner]

hello everyone,
here is my problem. I'm trying to turn any cell red that appears more than
once in a specifed column range. The problem is my cells have unique data in
them for example: John Beeman,1st,B1,Encapsulate. This data is all Indexed
and match from other sheets.
I tried going down the path of using
=countif($n$39:$n4$8,LEFT(n39,3)>1 but nothing shades red.
Any help on this, please please.

 

[Ms-Exl-Learner]

For shading the Duplicate Entry cells as Red Try this.
=IF(COUNTIF($D:$D,$D1)>1,COUNTIF($D$1:$D1,$D1)>1)

For shading the Original Entry cells as Red Try this.
=IF(COUNTIF($D:$D,$D1)>1,COUNTIF($D$1:$D1,$D1)=1)

Place the cursor in D1 and select the Entire Column
2. From menu Format>Conditional Formatting>
3. For Condition1>Select 'Formula Is' and enter the above codes whichever
you require.
4. Click Format Button>Font>Color select 'red' then give ok

You can change the Formula refence D column to your desired Column, but note
that while creating the conditional formatting the cursor should be in the
active cell as per the formula.

(Ex. here D1 is the Active cell so you have to place the cursor in D1 and
after that you have to select the Entire D column)

If this post helps, Click Yes!