Highlight Duplicate Values, Except a Particular Character(s)

Question

I'm trying to run a formula in Conditional Formatting to Highlight Duplicate values, except for (in this instance) X and V.

Below is the column I am trying to run the Conditional Formatting for, which I would like to know if any of the values are duplicate, except for the X's and V's (nor do I need the empty cells highlighted). Thank you in advance!

(sorry for the poor insert job)

A67
X
X
X
X
M61
A44
A37
X
M91
A4
V
M7
X
V
X
V
V
A11
M66
V
M68
A38
M34
M64
D8
D9
D2
V
D40
A39
D75
V
X
X
X
X
X
X
X
X
X
X
X
X
D64
X
X

Answer 1

Hi,

Suppose data is in range A2:A55.  Select cell A2 and go to Home > Conditional formatting > New Rule > Use a formula to determine which cells to format.  In the Formula bar there, enter this formula

=AND(COUNTIF($A$2:$A$55,$A2)>1,LEN($A2)>1)

Click on Format > Fill > Green > OK/Apply.  Now copy cell A2, select from A3:A55 > Right click > Paste Special > Formats > OK

Hope this helps.