Thanks in advance for your help. I have looked into many threads and other
websites but I now really confused. I am a moderate user of excel as most of
my time is spent in Access.

I want to look at every cell in column A and want to return a value for the
color in the cell to column O. I am using this for a formula to capture
certain data within cells.

--
Message posted via http://www.officekb.com