Conditional format to highlight duplicates Can't manipulate the data based on fill color

[bteddy1]

Hello,
I took data and conditionally formatted it to highlight-duplicates.
I see the dups and the yellow fill with red fonts.
When I try to write code to manipulate the data based on the fill color yellow all the data is treated the same.
When I wrote macros to verify the cell color
only (16777215, ffffff, -4142, d2efff) which are empty/no color/no fill) codes.

What is "conditional formatting" changing when it sets the fill color?? So I can reference it in code.

Thank You

 

[Eric W]

Welcome to MrExcel!

Looking for conditional formatting via VBA is tricky. Somewhere I have some code to look for it, which is pretty complicated and not reliable. However, since you have Excel 2010, you should be able to use the DisplayFormat method to see what the color is. Look here:

Range.DisplayFormat property (Excel)

Office VBA reference topic

docs.microsoft.com

 

[bteddy1]

Thank You

Got it to work.