Comparing cells in a column

[mfizz]

Hello,

i want to compare a column's cell to check for variation. The column it self has several parts and therefore is split using coloured cells. There are no variations allowed in each section.

eg. Using this as an example

Yellow coloured cell
ab
ab
ab
ab
Yellow coloured cell
ab
ab
ab
zz
ab
yellow coloured cell
green coloured cell
aa
aa
aa
aa
yellow coloured cell

This first section is fine. The second section should be flagged as they aren't the same. The third section is fine too.

Thanks in advance

 

[bewsh1987]

Hi,

where should this flag up

should it change the colour of a cell
should it change the text in a cell

Yellow coloured cell (( Change Colour) or (Change Text)) guessing
ab
ab
ab
zz
ab

 

[mfizz]

it should flag in a column offset 6 columns. i have managed to make it work however, i am having trouble identifying last row. the last row is a coloured cell. and therefore for the last section it doesn't calculate. can anyone help identifying the last row in a column that is coloured.
this is what i am using right now.

it identifies the last cell to be that of a cell with contents.

For i = 2 To Range(column_to_search & Rows.Count).End(xlUp).Row

Usedrange doesn't work either