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

Blaize

New Member
Joined
Aug 7, 2014
Messages
28
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

Active Member
Joined
May 11, 2002
Messages
304
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
 

Forum statistics

Threads
1,084,971
Messages
5,380,933
Members
401,705
Latest member
DravenExcel

Some videos you may like

This Week's Hot Topics

Top