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

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

  1. Libbie

    This is what good writing is made of; interesting, engaging, intelligent and well-written content. This is exactly what I see in your article. Thank you.

  2. nike basketball shoes

    I am only writing to let you know what a remarkable encounter my friend’s princess enjoyed reading your webblog. She noticed a wide variety of things, including what it is like to possess an ideal teaching nature to get other folks effortlessly fully understand selected extremely tough things. You really surpassed our own expectations. Thanks for rendering such beneficial, safe, revealing and in addition cool thoughts on your topic to Janet.

  3. best motorcycle gps

    If you are going to watch comical videos on the net then I suggest you to go to see this web site, it carries truly therefore comical not only video clips but also extra stuff.

  4. louboutin shoes

    Thanks a lot for providing individuals with remarkably brilliant opportunity to read articles and blog posts from this blog. It is usually so sweet and as well , packed with a great time for me and my office colleagues to search your blog more than three times per week to find out the latest things you have got. And indeed, we’re certainly satisfied for the exceptional things you serve. Selected 2 ideas in this posting are essentially the most efficient we’ve ever had.

  5. Tattoo

    Wow, superb blog layout! How lengthy have you ever been running a blog for? you make running a blog look easy. The entire look of your site is excellent, let alone the content material!

  6. find more here

    If you are ready to watch comical videos online then I suggest you to pay a visit this web page, it includes in fact so humorous not only movies but also additional data.

  7. off white

    I must convey my love for your kindness for those who should have guidance on this important issue. Your personal commitment to getting the solution up and down turned out to be surprisingly productive and have surely helped men and women much like me to reach their goals. Your personal informative key points means a whole lot a person like me and somewhat more to my office workers. Thanks a lot; from everyone of us.

  8. jordan shoes

    Thanks so much for providing individuals with an extremely wonderful opportunity to discover important secrets from this website. It’s always so great and as well , full of amusement for me and my office colleagues to search your site on the least three times weekly to read through the fresh secrets you have got. And indeed, I’m usually happy with the superb tricks served by you. Certain 4 facts in this article are surely the very best I’ve had.

  9. nike max

    I precisely needed to say thanks again. I do not know what I could possibly have handled without those aspects documented by you concerning my situation. It absolutely was a horrifying setting in my view, but noticing the very well-written way you dealt with the issue forced me to weep with joy. I’m just grateful for this advice and then pray you comprehend what a great job that you’re putting in teaching the rest through your webblog. Most probably you have never come across all of us.


    Have you ever considered about including a little bit more than just your articles?
    I mean, what you say is fundamental and all. But just imagine if you added some great images or video clips to give your posts more, “pop”!
    Your content is excellent but with images and videos, this blog could undeniably
    be one of the most beneficial in its niche. Superb blog!

Leave a Reply

Your email address will not be published. Required fields are marked *