Solved: Help!! Complete Excel newbie going into partial meltdown!!

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!

 

Thank you so much for offering to do this, it's really appreciated! I am sorry it took so long to reply, I went into hospital for surgery a day or two after and it totally slipped my mind. Here is the link: https://www.yousendit.com/download/T2dkWWVzTkx6RS9sZThUQw

First column labelled 'id' are where the names would be, the following two columns dated December 4th and 17th are the fields with the weights (the fields that I'd like formatting).

Thanks so much Oh and if you celebrate it, Happy Christmas

 

Thank you SO much for this...it's absolutely perfect. You have just made me life a million times easier!!!

Happy New Year