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!


E.g. below

By: Sean

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

  1. Acheter Fluoxymesterone Halotesting

    Can I simply say what a reduction to seek out someone who actually knows what theyre talking about on the internet. You definitely know the right way to convey a difficulty to gentle and make it important. Extra people must read this and perceive this facet of the story. I cant consider youre no more fashionable since you definitely have the gift.

  2. Jung

    That as in fact a good movie stated in this post about how to write a piece of writing, therefore i got clear idea from here.

  3. Eyequots

    [url=]advair disc[/url] [url=]synthroid generic[/url] [url=]lexapro 5 mg[/url] [url=]buy wellbutrin[/url] [url=]celebrex generic[/url] [url=]can i purchase clomid without prescription[/url] [url=]ventolin inhaler[/url] [url=]buy tadalafil[/url] [url=]retin-a 0.025[/url] [url=]indocin medication[/url] [url=]acyclovir tablet cost[/url] [url=]zoloft 50 mg[/url] [url=]metformin price south africa[/url] [url=]atarax 25[/url] [url=]doxycycline 100 mg capsule[/url] [url=]buy generic lipitor online[/url] [url=]atomoxetine strattera[/url] [url=]valtrex rx where to buy[/url] [url=]suhagra 100[/url] [url=]cheapest propecia for sale[/url]

  4. fs19 modhub

    You have made some decent points there. I looked on the internet for more information about the issue and found most people will go with your views on this site.


    I together with my friends appeared to be digesting the nice helpful hints found on the website and so at once got a terrible feeling I never thanked you for those secrets. Most of the guys had been for this reason joyful to see all of them and already have sincerely been loving these things. Appreciate your indeed being indeed accommodating and for making a choice on certain beneficial things most people are really needing to be informed on. My sincere apologies for not expressing appreciation to you sooner.

  6. herbalife

    Thanks for some other great post. Where else may anybody get that kind of information in such an ideal method of writing? I ave a presentation next week, and I am at the look for such information.

  7. T3 liothyronine kaufen

    It’s a shame you don’t have a donate button! I’d without a doubt donate to this brilliant blog! I guess for now i’ll settle for bookmarking and adding your RSS feed to my Google account. I look forward to fresh updates and will share this site with my Facebook group. Talk soon!

  8. yeezy

    I truly wanted to type a quick message in order to thank you for all of the splendid pointers you are giving here. My incredibly long internet search has at the end been compensated with beneficial points to exchange with my co-workers. I would believe that many of us readers are quite blessed to be in a decent network with very many lovely people with good principles. I feel pretty privileged to have discovered the web pages and look forward to plenty of more cool moments reading here. Thank you once again for everything.


    Definitely believe that which you stated. Your favorite
    justification seemed to be on the internet the simplest
    thing to be aware of. I say to you, I definitely get irked while people think about worries that they just don’t know about.
    You managed to hit the nail upon the top as well as defined out the whole thing without
    having side effect , people could take a signal. Will
    probably be back to get more. Thanks

  10. Matilda

    Greetings! Very helpful advice in this particular post!
    It’s the little changes which will make the greatest changes.

    Thanks a lot for sharing!

  11. michael kors factory outlet

    I want to show appreciation to the writer for bailing me out of this type of crisis. As a result of looking throughout the world-wide-web and meeting principles which are not helpful, I thought my life was over. Being alive minus the answers to the difficulties you’ve sorted out through this short post is a critical case, as well as ones which may have negatively damaged my career if I hadn’t encountered your web site. Your personal talents and kindness in handling every aspect was very helpful. I don’t know what I would have done if I hadn’t encountered such a subject like this. I can now relish my future. Thank you very much for your specialized and results-oriented help. I won’t think twice to recommend the sites to anyone who needs and wants tips on this subject.

  12. Tattoo Artists

    Very nice info and right to the point. I am not sure if this is in fact the best place to ask but do you people have any ideea where to get some professional writers? Thank you

Comments are closed.