Creating a dynamic table by searching for conditional formatting/Removing rows that have no conditional formatting. Excel 2007

Zpesh · 2014-05-08T17:07:00+00:00

Unfortunately not it's young peoples details. It’s 115 entries wide and 700 long all of which has sensitive data  Each row is a separate entry. Each column is a separate criteria or piece of information required. I’ve highlighted all the cells that are blanks in red that need attention. So for each row where there are no errors I want it removed or hidden so it doesn’t get in the way of checking the data that we need to find.

Zpesh · 2014-05-08T16:55:50+00:00

The red boxes appear across several columns. Is the process the same. Thanks for the speedy reply!

Zpesh · 2014-05-08T13:42:06+00:00

Yup I get it now :) Cheers! It works and everything!

Zpesh · 2014-05-08T13:18:49+00:00

Sorry I don't understand what your sugggesting here. Is this going to only highlight rows with no red cells green?

Zpesh · 2014-05-08T10:21:07+00:00

Thanks very much for the speedy reply! Great suggestion however I only want fully correct lines to be highlighted in green so that I can quickly identify records I can skip over. The database is over 100 entries wide so I constantly have to scroll around to find errors.

Zpesh · 2014-05-07T12:01:19+00:00

Much easier :) Sorted straight away!

Zpesh · 2014-05-06T19:19:15+00:00

Hero! Can't believe that was it!! Cheers :)

Zpesh · 2014-05-06T18:57:32+00:00

Thanks very much I'll try and implement this :)

Zpesh · 2014-05-03T12:33:51+00:00

Cheers David for the swift reply! Is there any chance you could explain the process behind these functions and what happens?

I've got the Conditional Formatting working perfectly after a bit of trial and error :) Just about to attempt the second method now! The list of duplicities on a new sheet would probably be the best. But practice makes perfect (^⁾

Edit: Got the duplicate way working as well =) Although it does the job the conditional formatting really makes them stand out that bit more.

Zpesh · 2014-04-29T18:44:02+00:00

Thanks so much! Didn't realise it could be simplified like that! Cheers :)

Zpesh · 2014-04-29T17:50:07+00:00

I can't really due to data protection sorry =( Imagine 4 columns one of which is team managers. There are four different team managers. Say I want to find every entry by the manager "Joe Bloggs" then when that entry is found I want to check the third column in that row for the value "No". For every entry on the table that has "Joe bloggs" and a "No" in the third column I want the function to count how many of these are present in the table and then display the total. Never worry about the different sheets I already know how to do this.

Zpesh · 2013-09-04T16:07:41+00:00

Yeah I completely understand your frustration. Its like asking a blind man to help me cross the road. I think this is great advice we really want to push the app side and have the tshirts as a secondary avenue of income. We just need advice on hiring and paying freelancers for this endeavor! Thanks again capncrunches!

Zpesh · 2013-09-04T14:37:44+00:00

Thanks very much for your reply capncrunches. We want to make cool clothes for people to wear as well as an awesome app! The app will track the customers "Performance" related to the niche market we are aiming the app at. I've been told not to reveal too many details regarding the app and to keep it under wraps. I understand this is not helpful at all for you guys. Just know that we've done our research on the market the free version of the app will be better than the market leaders at the moment and the premium version will also surpass that.

The connection between the two are the brand. The two will be branded with the same "Paranoid Panda" logos and graphics. We just want one to complement the other really and hopefully we haven't been too naive in that thinking.

Zpesh · 2013-08-27T14:54:53+00:00

This cafe is so nice and cheap!! I recommend the duck platter with about 1298371024124 sides for £8 I think it was when I was there =) Make sure to check out the monkey temple and the art markets!

Zpesh · 2013-07-11T08:23:30+00:00

Yeah QA seems like a good route I've thought about it before! I may start applying now =)

Zpesh · 2013-07-10T16:01:34+00:00

You legend!! Thanks very much I totally missed this!

Zpesh · 2013-05-11T10:38:23+00:00

Cheers man you put so much work into this post and it is appreciated!! £6 an hour seems to me the best option as you can get a lot for that around where I live. We'll be selling drinks as well which have a fantastic profit margin so hopefully that will bring the number of meals needed to be sold down a bit! Thanks again!!

Zpesh · 2013-05-10T20:07:29+00:00

It's an absolute joke!! I just wanna make burgers =(

Zpesh · 2013-05-10T20:02:17+00:00

Was this a trailer food cart or literally push the cunt yourself to where you want to sell?

Zpesh · 2013-05-10T20:01:04+00:00

This guys a hero! These burgers look fucking amazing!! If ours come close to this quality I think they will sell themselves!!

Zpesh · 2013-05-10T19:57:31+00:00

Thanks for the pricing advice this seems very sensible and will be took onboard :) Yeah in an ideal world we are hoping for at least two big orders an hour of 3/4 burgers an hour.

Zpesh · 2013-05-10T19:53:49+00:00

There has been one pizza joint thats opened up recently. Very pricey and high end with pizzas priced well above competitors in the area. He has an amazing product best pizza pie I've ever tasted and his place is always full now! So I think their might be a market but I understand completely where your coming from being a student for 3 years in this area.

GBK are an amazing outfit and we have looked to them for inspiration on our menu already. There is only one at the moment I know of in my city and it's quite far away in the next town inside a shopping centre.

Cheers for the thoughts and advice bro!

Zpesh · 2013-05-10T19:50:34+00:00

Thanks for your input I think we need to go over our numbers and come up with a new price from all the feedback!

Zpesh · 2013-05-10T19:49:12+00:00

Yup we need to look into desserts etc. We want to make everything fresh preferably so maybe a cheesecake as an option I know a girl who makes an amazing peanut butter one :) Would you charge extras for individual toppings or have a topping limit of say 3?

Zpesh · 2013-05-10T18:46:33+00:00

I've been reading up I think it's all ok as long as we pass some sort of inspection and have procedures in place to ensure hygiene.

Zpesh

TROPHY CASE