Conditional format cells only that contain a sequence of blanks

Hi all, I need some help trying to nut out a conditional formating formula.

I need to only highlight cells that contain 3 or more blanks in sequence in a row (range E2:O2)

The desired outcome is to highlight the cell A2 as row A has 3 or more blanks in a row. Following this A6 will highlight but the remaining A cells will remain not highlighted.

If any advice can be given for the forula to use it would be amazing!

Thanks

E.g. below

By: Sean

328 thoughts on “Conditional format cells only that contain a sequence of blanks

  1. Anabole steroide kaufen

    Having read this I thought it was very informative. I appreciate you taking the time and effort to put this article together. I once again find myself spending way to much time both reading and commenting. But so what, it was still worth it!

  2. Aplicativo Iptv Pc

    Ponto IPTV a melhor programacao de canais IPTV do Brasil, filmes, series, futebol, lutas, shows, documentarios em alta definicao de imagem e som em SD, HD, FULL HD, 4K. compativel com todos aparelhos do mercado Brasileiro.

  3. Buy Reductil

    Your style is so unique compared to many other people. Thank you for publishing when you have the opportunity,Guess I will just make this bookmarked.2

  4. anabolika kaufen

    Definitely imagine that which you said. Your favorite justification appeared to be at the net the easiest thing to keep in mind of. I say to you, I definitely get annoyed even as other folks consider concerns that they just don’t realize about. You controlled to hit the nail upon the top and defined out the whole thing without having side effect , folks could take a signal. Will likely be again to get more. Thanks

  5. potenzmittel online kaufen

    An interesting discussion is worth comment. I think that you should write more on this topic, it might not be a taboo subject but generally people are not enough to speak on such topics. To the next. Cheers

  6. buy injectable steroids

    Excellent read, I just passed this onto a colleague who was doing some research on that. And he just bought me lunch because I found it for him smile Thus let me rephrase that: Thank you for lunch! “We have two ears and one mouth so that we can listen twice as much as we speak.” by Epictetus.

  7. Reductil online kaufen

    Hi there, simply become aware of your weblog through Google, and located that it is truly informative. I’m gonna be careful for brussels. I will be grateful if you happen to continue this in future. A lot of other folks can be benefited out of your writing. Cheers!

  8. Acquistare Melanotan 2

    After research a number of of the blog posts on your website now, and I actually like your approach of blogging. I bookmarked it to my bookmark website record and might be checking again soon. Pls try my site as well and let me know what you think.

  9. Acquista Sibutril online

    Almost all of whatever you mention happens to be supprisingly accurate and that makes me wonder the reason why I had not looked at this with this light previously. This piece really did switch the light on for me as far as this topic goes. Nevertheless there is actually one factor I am not too comfy with so while I make an effort to reconcile that with the actual central idea of your issue, permit me observe just what all the rest of your visitors have to point out.Nicely done.

Comments are closed.