Highlighting Rows from Unique Value Conditional Format

[JamesVan]

I need help finding a way to highlight rows while doing a conditional format for the unique values of a column. For example if column had the values

1
1
2
3
3

I would want the entire row 3 highlighted. Also if anyone knows a way to write a macro do the conditional format across workbooks that would be of great help so I don't have to paste over the values that I am comparing. ​

 

[RickXL]

Hi,

It sounds as if you need to use COUNTIF to count the number of times a given number occurs in a column.

I have assumed the keys are in column A and the range required is A2:N7. Obviously you could change that.
Below is a macro recording of those settings with unique rows highlighted in blue, or 15773696 as we programmers say

Sub ConditionalFormat()
    Cells.FormatConditions.Delete
    Range("A2:N7").Select
    Range("A2").Activate
    Selection.FormatConditions.Add Type:=xlExpression, Formula1:= _
        "=COUNTIF($A:$A,$A2)=1"
    Selection.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority
    With Selection.FormatConditions(1).Interior
        .PatternColorIndex = xlAutomatic
        .Color = 15773696
        .TintAndShade = 0
    End With
    Selection.FormatConditions(1).StopIfTrue = False
End Sub

 

[JamesVan]

This works great for what you wrote it to do however how can I make it Highlight the rows in which it finds the unique values?