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

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

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!
 

etaf

Wayne
Moderator
Joined
Oct 2, 2003
Messages
65,478
conditional formatting would probably be the best to use for this

if you want to load some dummy data here in a spreadsheet - we can enter the conditional format into the spreadsheet and then explain how to do that

you should just be able to use the cell value

example here testing the previous cell
 

Attachments

babygyalsw2

Thread Starter
Joined
Apr 18, 2007
Messages
16
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 :)
 

babygyalsw2

Thread Starter
Joined
Apr 18, 2007
Messages
16
Thank you SO much for this...it's absolutely perfect. You have just made me life a million times easier!!!

Happy New Year :)
 

etaf

Wayne
Moderator
Joined
Oct 2, 2003
Messages
65,478
excellent - (y) thanks for letting us know
You can mark your own threads solved using the
button at the top of the page of the thread in the upper left corner.
:)

Unless you need to refine at all
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top