Can I base VBA\Formula off of conditional formatted cell?

[Legacy 296647]

I have a column that looks for duplicates, and makes them fill color and font color red.

What I would like to do if possible is in another column look at conditional formatted column and return text\values or anything that has a duplicated cell which is fill color red and font color red.

Is this even possible being that I am using conditional formatting? This is not manual coloring which I know how to do by looking up 255 for red color.

 

[ACommandLineKindaGuy]

You don't need VBA.

If your data is in column A starting on row 2 and ending on row 999, enter the following formula in cell B2:
=IF(ISNA(VLOOKUP(A2,A3:A$999,1,FALSE)),"","DUPLICATE")
That will give you the 1st instance of the duplicate.

If you want to find all duplicates, then use the following:
=IF(ISNA(VLOOKUP(A2,A3:A$999,1,FALSE)),"","DUPLICATE BELOW")&IF(ISNA(VLOOKUP(A2,A$2:A2,1,FALSE)),"","DUPLICATE ABOVE")


Whichever formula you use, copy from B2 to B3:B999