Find first and last cells in column that have a certain fill color
 

Hello All,

I am looking to create a macro that looks at a column, finds the first cell
in that column that has a green (colorindex=35) fill color and names it
(named range). Then I would like the macro to find the last cell in the
column that has that same color fill and name that one as well. Then I would
like to be able to reference the range that falls between the two named
cells and have the macro perform text to columns on it. Does anyone have any
ideas on how I might achieve this? Thanks in advance,

Ashleigh