searching for cell colors

[Luis939]

i dont know if this is possible, but is there a way to use something like the FIND method, which looks for color indices. so that basically i can just find the first cell which is color index = 53 or anything else?? thanks!!

 

[Chattin]

This may be of some use to you

http://www.cpearson.com/excel/colors.htm

HTH

Chris ;-)

Visit

http://www.mrexcel.com/board/index.php

for great xl and xl/VBA help

 

[Luis939]

thanks but i did realize beforehand that i would have to test each cell in a range i defined to check if it had the color i was looking for, i just wanted to konw if there was a simple easy one step instruction that could find a cell with that color, much like the .find method can find a cell with a piece of text in just one step, but i guess not, thanks!!