CODEWITHSUNDEEP
excelexcel-formulaworksheet-functionconditional-formatting
Captain Walker
Captain Walker

Reputation: 9

Highlighting repetitions in rows

I'm trying to find a way of finding repetitions in a whole set of rows and having much difficulty. I'm no Excel expert. I have looked at many formulas on finding duplicates in columns but am unable to transpose those to finding repetitions in rows only. I'll explain. See diagram:

In essence I would like to have highlighted the same words in rows if repeated three times (and in different colours by different keywords).

As you can see this would quickly enable finding those key positions where I get three 'FIRED' and three 'LONG' flash up coincidentally in the same row, with much less effort.

Upvotes: 0

Views: 68

Answers (1)

pnuts
pnuts

Reputation: 59440

A CF formula rule of: 

=OR(AND(A1=B1,A1=C1),AND(B1=C1,B1=D1),AND(C1=D1,C1=E1))

applied to Columns C:H should find any three consecutive cells in a row where the value is the same.

For filling with different colours each colour would require a separate rule, for example: 

=OR(AND(A1=B1,A1=C1,A1="Fired"),AND(B1=C1,B1=D1,B1="Fired"),AND(C1=D1,C1=E1,C1="Fired"))

should work for pale blue:

SO31536207 example

Upvotes: 2

Related Questions