HELP : Extract value with criteria color

[susanto]

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]

cross posted at least in one other place:http://www.mrexcel.com/forum/excel-q...ackground.html