Highlighting a specific amount of consecutive value

[navalarc]

Hello all,

I have just registered this forum for the below problem that I could not find out how to solve.

I have uploaded my excel list and would like to explain my situation on this.
If the amount of the cell values named with W reach the required number (as 4 in example) then the fifth cell needs to be highlighted.
And I will enter data manually so if I write F to the highlighted cell manually when I see the highlight, the formula needs to kept and continues for the further cells and searches for the same criteria to meet in the following cells.

Many thank you in advance.

[Croweater]

=AND(COUNTIF($C2:C2,"W")>$B2,C2="W") in your conditional format in C2 and drag across and down.

[navalarc]

Hi Croweater,

It does not work because it counts the total number, not the consecutive.
If the W are 3 in row, not 4, it should not be highlighted.

At your formula, it highlights all the W s after reaching 4, does not take into account if they are consecutive or not.

test2.jpg

[JeteMc]

As the first cell which could follow four W's would be cell G2, use the following formula as a conditional formatting rule applied to: =$G$2:$N$2

Please Login or Register  to view this content.

Let us know if you have any questions.