Conditional Formatting Throughout

In conditional formatting, I have

=$A$5=”x” (Formats the target cells to Fill Green) Applies to =$B$5:$T$5

This causes cells B5 through T5 to highlight green if cell A5 is x.

I’m using this to highlight work orders that have been completed in my work schedule. If the job is complete, I put an x in the first cell of the row and it highlights all the cells in that row up to cell T5.

Is there a way to use this for the entire document or even 50 rows without having to create a new rule for every single row I want to use it for?

By: Travis

29 thoughts on “Conditional Formatting Throughout

  1. ig

    Wonderful article! That is the kind of info that should be shared around the
    net. Shame on Google for now not positioning
    this post higher! Come on over and visit my web site .
    Thank you =)

  2. balenciaga shoes

    Thanks so much for providing individuals with an extraordinarily special opportunity to check tips from this website. It is often very brilliant and as well , full of amusement for me personally and my office fellow workers to search the blog really 3 times a week to read through the fresh guides you have got. And of course, we are always contented with the tremendous information you give. Selected 4 points in this article are basically the most effective we have all had.

  3. Brookwood Camps

    Yesterday, while I was at work, my sister stole my apple
    ipad and tested to see if it can survive a
    twenty five foot drop, just so she can be a youtube sensation. My
    iPad is now destroyed and she has 83 views. I know this is
    completely off topic but I had to share it with someone!

  4. moncler

    Thank you a lot for providing individuals with an exceptionally wonderful chance to check tips from this blog. It is usually so beneficial and also packed with a lot of fun for me and my office mates to visit your site no less than 3 times in 7 days to read the new tips you will have. And of course, I am actually pleased with all the powerful ideas served by you. Certain 3 facts in this posting are undoubtedly the simplest we have had.

  5. Tyrell Arbolida

    I was just looking for this information for a while. After 6 hours of continuous Googleing, at last I got it in your website. I wonder what is the lack of Google strategy that don’t rank this kind of informative websites in top of the list. Usually the top web sites are full of garbage.

  6. air max 97

    Needed to put you that little bit of note just to say thanks once again over the magnificent suggestions you have documented here. It’s simply shockingly generous with people like you to grant freely what exactly a number of us could possibly have offered for an e-book to help make some profit on their own, precisely given that you could have tried it if you ever desired. Those points likewise served as a fantastic way to be aware that the rest have similar passion like my personal own to grasp a good deal more with regards to this problem. I am certain there are some more enjoyable opportunities ahead for those who look into your blog.

  7. coach outlet store online

    Thank you for your own efforts on this web site. My daughter loves going through investigation and it’s really obvious why. All of us hear all relating to the lively medium you provide priceless tips via the website and as well cause response from other people on this area of interest so our own child is undoubtedly learning a lot of things. Enjoy the rest of the year. You have been carrying out a great job.

  8. vans shoes

    I intended to write you this very little word so as to say thank you once again for your personal spectacular advice you’ve provided in this article. This is simply remarkably open-handed of people like you to deliver unreservedly what a few people could have supplied for an e book to help make some dough for themselves, even more so seeing that you could have tried it in case you wanted. The smart ideas as well acted to provide a good way to comprehend some people have the same dream like my very own to figure out many more pertaining to this problem. I think there are numerous more enjoyable times in the future for folks who read your site.

  9. sling tv

    I like what you guys tend to be up too. This sort
    of clever work and exposure! Keep up the excellent works guys I’ve included
    you guys to my blogroll.

  10. air jordan

    I must show my thanks to you just for bailing me out of this particular problem. After researching throughout the the web and getting tricks which were not productive, I thought my life was gone. Existing minus the approaches to the issues you’ve sorted out all through the write-up is a critical case, and the kind that might have adversely affected my career if I hadn’t come across the blog. Your main competence and kindness in playing with every aspect was invaluable. I’m not sure what I would’ve done if I had not discovered such a stuff like this. I am able to at this time look forward to my future. Thank you very much for your impressive and sensible help. I won’t be reluctant to endorse your web sites to anyone who desires counselling about this situation.

  11. retro jordans

    Thank you so much for giving everyone an extraordinarily nice opportunity to read in detail from this site. It’s usually very fantastic and as well , full of a great time for me and my office co-workers to visit your blog at a minimum 3 times in a week to see the new items you have got. And indeed, we’re always motivated with all the incredible tips and hints you give. Certain 4 facts in this article are basically the finest we have all ever had.

  12. yeezy wave runner 700

    I enjoy you because of all of the hard work on this website. Ellie takes pleasure in carrying out internet research and it’s really simple to grasp why. My spouse and i know all concerning the powerful way you render very helpful tips on your web blog and in addition foster participation from some others about this area while my princess is certainly understanding a great deal. Take advantage of the rest of the new year. You are always doing a tremendous job.

  13. air jordan

    I am glad for commenting to make you know what a impressive experience our daughter found reading your web site. She discovered several pieces, with the inclusion of what it is like to possess a wonderful coaching nature to get the rest with ease thoroughly grasp several very confusing topics. You actually surpassed readers’ expectations. Thank you for producing these warm and helpful, dependable, revealing and even unique guidance on this topic to Sandra.

  14. supreme clothing

    I together with my pals were reading the excellent helpful hints from your web blog then at once came up with a horrible feeling I never expressed respect to the website owner for those tips. The boys came as a consequence very interested to study all of them and now have without a doubt been using those things. Appreciate your actually being well considerate and for having this sort of superior issues most people are really wanting to learn about. Our honest regret for not saying thanks to you sooner.

  15. christian louboutin shoes

    I am commenting to make you know of the excellent experience my daughter went through checking yuor web blog. She noticed numerous pieces, not to mention what it is like to possess a marvelous giving heart to let other people effortlessly know specific extremely tough subject areas. You really exceeded visitors’ expectations. Many thanks for delivering these great, dependable, edifying and in addition unique guidance on that topic to Lizeth.

  16. Spencer Higbie

    I was very pleased to find this web-site.I wanted to thanks for your time for this wonderful read!! I definitely enjoying every little bit of it and I have you bookmarked to check out new stuff you blog post.

  17. ps4 games

    I was more than happy to discover this website. I want to to thank you for your time just for this wonderful read!!
    I definitely liked every part of it and I have you saved as a
    favorite to look at new information in your web site.

  18. calvin klein

    An impressive share, I simply given this onto a colleague who was doing somewhat evaluation on this. And he in reality bought me breakfast because I discovered it for him.. smile. So let me reword that: Thnx for the treat! But yeah Thnkx for spending the time to debate this, I really feel strongly about it and love reading more on this topic. If attainable, as you change into experience, would you mind updating your weblog with extra particulars? It’s extremely helpful for me. Large thumb up for this blog submit!

  19. adidas gazelle sale

    Good post. I learn something tougher on different blogs everyday. It’s going to all the time be stimulating to read content from other writers and follow somewhat one thing from their store. I抎 desire to make use of some with the content on my blog whether you don抰 mind. Natually I抣l offer you a link in your web blog. Thanks for sharing.

  20. quest bars cheap

    You’ve made some really good points there. I looked on the internet for more information about the issue and found most individuals will go along with your views on this site.

  21. off white hoodie

    I抦 impressed, I must say. Really rarely do I encounter a weblog that抯 each educative and entertaining, and let me tell you, you could have hit the nail on the head. Your thought is outstanding; the difficulty is one thing that not sufficient persons are talking intelligently about. I am very happy that I stumbled throughout this in my seek for something referring to this.

  22. yeezy boost 350

    I am typically to running a blog and i actually recognize your content. The article has actually peaks my interest. I am going to bookmark your site and preserve checking for brand spanking new information.

  23. coach handbags

    I was very pleased to find this internet-site.I needed to thanks on your time for this glorious read!! I undoubtedly having fun with every little little bit of it and I’ve you bookmarked to take a look at new stuff you blog post.

Comments are closed.