Can VBA find a cell that meets Conditional Formatting criteria?

[aquixano]

I have a workbook that quarterly I update a list of IDs based on changes to their population. In the example workbook attached column A contains the existing IDs and in Column B I import the new values – the list can be up to a couple thousand IDs long. I need to see the changes, so I’ve created conditional formatting rules that highlight miss matches. Anything in the current list that’s no longer in the new import is heighted red for deletion, and anything in the import that needs to be added is highlighted Green. A blue highlight in column means an ID has been duplicated and requires investigation.
Question – Can I identify which cells in column A are highlighted, either red or blue? Currently I scroll through the list manually, but was wondering if I could click a macro to jump to the next highlighted cell in column A. If this is possible, I would appreciate a suggested direction to investigate – I’m not sure how to start this one and have struck out searching on the internet.

[kalbasiatka]

    If Cells(i, j).Interior.Color = 255 Then 'red
        'some action
    End If
    If Cells(i, j).Interior.Color = 32768 Then 'green
        'some action
    End I

f

[aquixano]

I like your thinking, unfortunately conditional formatting doesn't change the interior.color value (it's always 16777215), despite what's the display color.

[kalbasiatka]

walk through the cells and apply the same rules in the conditional formatting in code

[shg]

Why not just autofilter based on cell color?

[aquixano]

In the large list the differences are rarely on the same line, so filtering on one column would hide many of the changes in the other column.

[shg]

You could add a formula that calculates if any of the cells in the row are of interest, and filter on that.

And if you do that, you could use the same column to control the CF so you don't do it redundantly.