I am using the conditional formatting to highlight duplicate values. Then I want to check for all the highlighted cells and count the duplicates (dividing by 2). The conditional formatting records the interior color used to highlight is 13551615, but it doesn't recognize that the highlighted cells are this color later.
To highlight duplicates
To count highlighted cells
Please Login or Register to view this content.
Please Login or Register to view this content.
I have checked with a bit of code and:
It looks like Excel doesn't recognise the fact that the color is changed by a conditional format.
You may have to check for duplicates in Visual Basic
.Interior.Color returns the "real" color, not the conditionally-formatted color result..
Last edited by mehmetcik; 04-13-2013 at 05:52 PM.
Pearson spells it out really nicely here: http://www.cpearson.com/excel/CFColors.htm
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks