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

7 thoughts on “Problem with cell conditional formatting

  1. 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!?

  2. 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!

  3. 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.

  4. 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

  5. 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.

  6. 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!

Leave a Reply

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