PDA

View Full Version : HELP : Extract value with criteria color



susanto
09-26-2013, 10:16 AM
hi expert...

i have set data with contain 2 cell color, blue and yellow..
i want to extract which only data/value with contain blue, can be extract



product

after vba



mango (cell color yellow)




papaya (cell color blue)

papaya



orange (no cell color)




banana (cell color blue)

banana




it's possible??

for somebody help me, i appreciated....

thank in advance..........

p45cal
09-26-2013, 10:59 AM
cross posted at least in one other place:http://www.mrexcel.com/forum/excel-questions/729154-visual-basic-applications-need-help-extract-contain-2-cell-color-background.html