babygyalsw2
Thread Starter
- Joined
- Apr 18, 2007
- Messages
- 16
Hi everyone!!
I am currently writing down all the weekly weights of my reptiles on paper - it's a nightmare! The purpose of the records are to check who loses or puts on weight from week to week so we can get an idea of anything being wrong over a period of time, and their general level of health. It contains: Name, the date/week, weight. I usually highlight in different colours who has put on weight and who loses weight, so I can quickly determine who needs an a watchful eye.
I want to start inputting information into a database. The thing I had in mind initially was a say a reptile's week 2 entry being the same or less than it's week one entry, the field would turn red - and in week 3 if the entry was less or equal 2 week 2's entry, it'd turn red. If it was greater than it'd stay a clear field.
I have tried to go about this all another way but why do I feel like I am overcomplicating the initial problem?! Here's what I have so far:
As you can see, I have autofilter on and at the moment I am setting up filters such as greater than or equal to 50 and less than 50 and it filters well, in the same fields as the original info. However, I want to filter the info for each week but have it copied to a different place, for arguments sake H1:L6 (name and weight) - it'd need an advanced filter right??. The bit I am having a problem with is this:
Here is the advanced filter box - what on earth goes in each of these three fields?
I have probably gone about this all wrong. I've gone with my very limited knowledge of Excel and tried to solve my problem but I've come to a complete brick wall, mainly through a lack of confidence with it all too. I'd really appreciate some help, or if you could explain in idiot terms a better way of going about the whole thing I'd be even more grateful!! If you could provide me the tools to have the initial highlighting idea - it'd make my xmas!!!!!
Thanks in advance!
I am currently writing down all the weekly weights of my reptiles on paper - it's a nightmare! The purpose of the records are to check who loses or puts on weight from week to week so we can get an idea of anything being wrong over a period of time, and their general level of health. It contains: Name, the date/week, weight. I usually highlight in different colours who has put on weight and who loses weight, so I can quickly determine who needs an a watchful eye.
I want to start inputting information into a database. The thing I had in mind initially was a say a reptile's week 2 entry being the same or less than it's week one entry, the field would turn red - and in week 3 if the entry was less or equal 2 week 2's entry, it'd turn red. If it was greater than it'd stay a clear field.
I have tried to go about this all another way but why do I feel like I am overcomplicating the initial problem?! Here's what I have so far:

As you can see, I have autofilter on and at the moment I am setting up filters such as greater than or equal to 50 and less than 50 and it filters well, in the same fields as the original info. However, I want to filter the info for each week but have it copied to a different place, for arguments sake H1:L6 (name and weight) - it'd need an advanced filter right??. The bit I am having a problem with is this:

Here is the advanced filter box - what on earth goes in each of these three fields?
I have probably gone about this all wrong. I've gone with my very limited knowledge of Excel and tried to solve my problem but I've come to a complete brick wall, mainly through a lack of confidence with it all too. I'd really appreciate some help, or if you could explain in idiot terms a better way of going about the whole thing I'd be even more grateful!! If you could provide me the tools to have the initial highlighting idea - it'd make my xmas!!!!!
Thanks in advance!