Excel 2007
I am using the following code to find duplicates and change the font to red. The code works well.
Next, I would like to change the cell color to vbYellow (cell color in column E) if there are three of the same number in column I.
And then, change the cell color to vbGreen if there are no matches.
Any advice?
Thanks, in advance.
I am using the following code to find duplicates and change the font to red. The code works well.
Code:
NUMROWS = ActiveSheet.UsedRange.Rows.Count
Range("E2:E" & NUMROWS).Select
Set uv = Selection.FormatConditions.AddUniqueValues
uv.DupeUnique = xlDuplicate
uv.Font.Color = vbRed
Next, I would like to change the cell color to vbYellow (cell color in column E) if there are three of the same number in column I.
And then, change the cell color to vbGreen if there are no matches.
Any advice?
Thanks, in advance.