conditional formating

[kerm007]

Hello how can i do conditional formatting when the same character appear 4 time in a row in let say row B3 to b24
i tries different thing but what i found is only for a column
Thanks

 

[SanjayGMusafir]

Glad to help you

Thanks for your patience

 

[kerm007]

hello quick one is there a way to get only sequence of 4 highlighted cause if i put an x to the 5 one its stay higlighted 4 in a row but if they came 8 times in a row it's 2 sequences
Thanks

 

[SanjayGMusafir]

hello quick one is there a way to get only sequence of 4 highlighted cause if i put an x to the 5 one its stay higlighted 4 in a row but if they came 8 times in a row it's 2 sequences
Thanks

So to understand better -
# You want first 4 to be highlighted
# And then if next 4 are completed they also get highlighted
# It should not follow along with every new "x" you put

Can be done. I have to think a way out.

Please confirm above. Till then I think of some workable solution.

 

[kerm007]

Yes but it will be another sequences
maybe we could add like a bold square every time a sequence of 4 is found ?
Thanks

 

[SanjayGMusafir]

So to understand better -
# You want first 4 to be highlighted
# And then if next 4 are completed they also get highlighted
# It should not follow along with every new "x" you put

Can be done. I have to think a way out.

Please confirm above. Till then I think of some workable solution.

Unable to work on that. It gives error with prevailing rules.

 

[kerm007]

ok ty

 

[kerm007]

hello
let me know if you found something
regards

 

[SanjayGMusafir]

hello
let me know if you found something
regards

No I didn't. I told you it was giving error to prevailing rules. So stopped working on it.

 

[kerm007]

ok cool thanks
i will live with it

 

[kerm007]

hello it work well but can we add something like after 4 consecutive x it became red but the 5 times they came it's another streak starting ?
Thanks