Problem with cell conditional formatting

My problem is based around an excel sheet being used to produce rotas which are then stripped to submit payroll hours.

There are names of people on this payroll sheet and next to the names in the cell to the right are the hours they have done.

I’ve used the conditional formatting tab on excel so that if the hours section next to the name has been left blank then the cell turns red.

However not all areas of the rota have names in the cells and i don’t want most of the sheet to be coloured red.

Is it possible to to combine this conditional formatting with a rule where the cell only turns red if there is actually data in the cell to the left of it. For example an employees name?

By: Christian

29 thoughts on “Problem with cell conditional formatting

  1. nike air max

    My spouse and i felt now fulfilled that Raymond managed to do his inquiry through your ideas he obtained in your blog. It’s not at all simplistic just to find yourself releasing tactics which some other people might have been making money from. And we also do know we have you to appreciate for that. The main illustrations you made, the straightforward website navigation, the relationships you will make it possible to engender – it is everything extraordinary, and it’s facilitating our son in addition to our family imagine that that subject is fun, and that is extraordinarily indispensable. Many thanks for everything!

  2. supreme

    I simply wished to thank you so much once again. I’m not certain the things that I would have taken care of without the tips and hints discussed by you relating to my subject matter. This has been an absolute frightening setting in my position, nevertheless understanding a specialized style you solved the issue forced me to jump over joy. Now i’m happier for your advice and even hope that you find out what a great job that you’re getting into training people thru your web blog. I know that you’ve never got to know any of us.

  3. ig

    We stumbled over here different web page and thought
    I may as well check things out. I like what I see
    so now i am following you. Look forward to looking at your web page yet again.

  4. Fiona

    This is the right webpage for everyone who would like to understand this topic.
    You know so much its almost tough to argue with you (not that I
    really will need to…HaHa). You certainly put a brand new spin on a subject which has been discussed for ages.

    Great stuff, just excellent!

  5. kobe sneakers

    I enjoy you because of all of the labor on this web site. Debby loves setting aside time for investigations and it’s easy to understand why. A number of us notice all of the lively mode you make functional items through the blog and as well as boost participation from other people on this area of interest and our favorite simple princess is without a doubt understanding a lot. Take advantage of the rest of the year. You’re the one conducting a really great job.

  6. nike shox

    Thank you for your own efforts on this website. My mum take interest in carrying out investigations and it’s simple to grasp why. We all know all about the dynamic way you produce effective techniques on the blog and therefore strongly encourage response from the others on the situation so our simple princess is now discovering a lot. Have fun with the remaining portion of the year. You have been conducting a really great job.

  7. off white clothing

    My spouse and i have been very thankful Albert managed to conclude his web research using the precious recommendations he came across in your blog. It is now and again perplexing to just be giving out things which other folks might have been selling. And we also acknowledge we have the website owner to give thanks to for this. The most important illustrations you have made, the easy site navigation, the relationships you will make it possible to foster – it is most amazing, and it’s really helping our son and the family feel that that idea is cool, which is wonderfully pressing. Thanks for the whole thing!

  8. supreme clothing

    I needed to send you this bit of remark to be able to thank you very much the moment again with your remarkable techniques you’ve featured in this article. This is so remarkably generous of you to grant without restraint what many people could have marketed for an e book to end up making some bucks for themselves, precisely considering the fact that you might have tried it if you ever considered necessary. These inspiring ideas additionally served as the fantastic way to be certain that some people have the identical dream just as my own to realize a lot more concerning this problem. Certainly there are some more pleasurable periods up front for folks who looked at your site.

  9. retro jordans

    I just wanted to write a brief note in order to say thanks to you for the fantastic guides you are showing at this site. My extended internet lookup has finally been rewarded with beneficial facts to write about with my friends and family. I would assume that we website visitors are unquestionably blessed to dwell in a fabulous community with so many special individuals with very beneficial tricks. I feel truly fortunate to have used your webpages and look forward to tons of more awesome minutes reading here. Thanks once more for everything.

  10. Cheri

    Today, I went to the beach with my children. I found a
    sea shell and gave it to my 4 year old daughter and said “You can hear the ocean if you put this to your ear.”
    She put the shell to her ear and screamed. There was a hermit
    crab inside and it pinched her ear. She never wants to go back!

    LoL I know this is completely off topic but I had to tell someone!

  11. hermes belts for men

    I want to get across my respect for your kind-heartedness giving support to people who really need assistance with your idea. Your personal commitment to passing the solution all over appeared to be unbelievably invaluable and have usually permitted folks just like me to attain their ambitions. Your informative help denotes much to me and additionally to my colleagues. Regards; from all of us.

  12. balenciaga

    I together with my guys appeared to be reading through the nice helpful tips found on your website and so all of the sudden developed a terrible suspicion I never thanked the web blog owner for those tips. The ladies had been glad to learn them and have now truly been taking pleasure in them. We appreciate you simply being well thoughtful as well as for deciding on this kind of amazing information millions of individuals are really eager to know about. Our own sincere apologies for not expressing gratitude to sooner.

  13. supreme

    I needed to write you this very little observation to thank you yet again regarding the precious methods you have shown on this website. It’s certainly seriously open-handed of people like you to provide unhampered just what a few people would’ve supplied for an e-book to get some dough for themselves, most notably considering that you might well have done it if you desired. Those concepts in addition worked as a great way to recognize that some people have a similar fervor just like my very own to grasp a lot more with reference to this condition. I believe there are lots of more pleasurable occasions up front for those who start reading your website.

  14. balenciaga

    I and my pals appeared to be following the best helpful tips located on the blog and unexpectedly I had a horrible feeling I never expressed respect to the website owner for those secrets. My women are actually happy to study all of them and now have extremely been using them. I appreciate you for actually being very kind and also for going for such perfect subject matter most people are really desperate to be aware of. Our sincere apologies for not saying thanks to earlier.

  15. hermes belts

    I have to show my gratitude for your kindness in support of those people that must have help with this important content. Your very own dedication to passing the message all over was particularly insightful and have truly encouraged professionals much like me to arrive at their objectives. Your own informative facts means a lot a person like me and much more to my colleagues. Thanks a ton; from everyone of us.

  16. golden goose outlet

    I want to express thanks to you just for bailing me out of this particular scenario. After surfing around throughout the world wide web and getting recommendations that were not pleasant, I assumed my life was done. Living devoid of the strategies to the issues you have sorted out by way of your main article content is a serious case, and those which could have adversely damaged my career if I had not discovered your blog post. Your good natural talent and kindness in controlling all things was very helpful. I am not sure what I would’ve done if I had not discovered such a solution like this. I can at this time look forward to my future. Thanks a lot very much for your high quality and amazing guide. I will not think twice to suggest your blog to anyone who should get tips on this situation.

  17. kevin durant shoes

    I actually wanted to send a small remark so as to say thanks to you for some of the fabulous tips and tricks you are placing here. My particularly long internet research has at the end of the day been recognized with professional information to exchange with my guests. I would mention that many of us site visitors are very much lucky to be in a really good website with very many awesome people with interesting secrets. I feel quite lucky to have used your site and look forward to tons of more enjoyable minutes reading here. Thanks a lot once again for all the details.

  18. kyrie shoes

    I precisely desired to say thanks again. I am not sure the things I might have made to happen in the absence of the methods contributed by you directly on my theme. It absolutely was a real distressing setting in my position, but seeing a specialized manner you treated the issue made me to leap for contentment. Extremely happier for the service and hope you find out what an amazing job that you’re providing training people today through your blog. I am sure you haven’t met any of us.

  19. off white hoodie

    I precisely wanted to thank you so much again. I’m not certain the things I would’ve gone through without the entire techniques contributed by you directly on such a situation. Previously it was the intimidating dilemma for me, however , taking note of your well-written mode you treated it took me to weep for joy. Now i’m happier for the assistance as well as hope that you really know what a great job your are getting into teaching some other people all through your blog. Most likely you’ve never come across all of us.

  20. nike shoes for men

    I and my guys have been examining the best helpful tips on your web page and then all of a sudden I got an awful feeling I never expressed respect to the site owner for those techniques. All the boys came absolutely joyful to study all of them and already have definitely been using these things. Appreciation for actually being simply thoughtful and also for considering such beneficial issues millions of individuals are really eager to be informed on. Our sincere apologies for not expressing appreciation to sooner.

  21. westbrook shoes

    I have to get across my respect for your kind-heartedness giving support to all those that require guidance on this particular niche. Your special dedication to passing the solution all around appears to be exceedingly insightful and have specifically enabled associates like me to reach their ambitions. Your important tips and hints means a whole lot to me and substantially more to my office colleagues. Many thanks; from all of us.

  22. converse outlet

    A formidable share, I just given this onto a colleague who was doing a bit evaluation on this. And he the truth is purchased me breakfast as a result of I found it for him.. smile. So let me reword that: Thnx for the treat! However yeah Thnkx for spending the time to discuss this, I really feel strongly about it and love reading more on this topic. If doable, as you become expertise, would you thoughts updating your blog with more particulars? It is extremely useful for me. Huge thumb up for this weblog put up!

  23. kyrie 5 shoes

    The next time I read a blog, I hope that it doesnt disappoint me as much as this one. I mean, I know it was my choice to learn, but I really thought youd have something fascinating to say. All I hear is a bunch of whining about one thing that you would repair should you werent too busy searching for attention.

  24. nike air force 1 low

    There are some attention-grabbing cut-off dates on this article however I don抰 know if I see all of them heart to heart. There may be some validity however I’ll take hold opinion until I look into it further. Good article , thanks and we want extra! Added to FeedBurner as effectively

  25. supreme hoodie

    I’m usually to running a blog and i really respect your content. The article has actually peaks my interest. I am going to bookmark your web site and maintain checking for brand new information.

  26. golden goose sneakers

    Youre so cool! I dont suppose Ive read anything like this before. So good to seek out any person with some original thoughts on this subject. realy thank you for beginning this up. this web site is one thing that’s needed on the internet, someone with somewhat originality. helpful job for bringing something new to the internet!

  27. air jordan shoes

    I found your blog website on google and check just a few of your early posts. Continue to maintain up the very good operate. I simply further up your RSS feed to my MSN News Reader. Searching for ahead to reading more from you afterward!?

Comments are closed.