Tim Mousel

Hi,

I want to use a simple spreadsheet to keep track of who paid their monthly dues.

I would like the spreadsheet to automatically show who is late and who is current based on their assigned due date.

I attached what I have so far. Any help would be much appreciated to get me going in the right direction.

Thanks,

Tim

Attached Files

Membership Dues.zip (5.2 KB, 29 views)

Hardball

I have over 20 years experience with spreadsheets. Give a second to take a look at watch you are talking about.

__________________
The Way of the Warrior is Practice. Daily practice, accumulate practice minute by minute, hour by hour and day by day. {Book of 5 Rings} Mike Brewers 2008 Sit up challenge 29,000/100,000 running balance.(Crunches) Kicks 6,300/100,000

Hardball

Those "if" forumulas you are using are complex. You said you wanted a simple spreadsheet. Unless you really know excel I would abandon the "if" formula and go to a more simple format using columns (down) instead of rows (across). Also instead of using words like "paid" and late I would just use the dollar amount.

Hope that helps some, if you revise it, I'll take a second look.

__________________
The Way of the Warrior is Practice. Daily practice, accumulate practice minute by minute, hour by hour and day by day. {Book of 5 Rings} Mike Brewers 2008 Sit up challenge 29,000/100,000 running balance.(Crunches) Kicks 6,300/100,000

Tom Yum

Hey Tim, look up Conditional formatting in the help section. You can use color to indicate if a data point (in your case tuition) is less then the monthly value.

Hope this helps.

Tom Yum

uhhhh Tim, did you find what you needed?

Conditional Formating.

__________________

Love it, leave it or fix it.

Tim Mousel

Hi,

I didn't find what I needed...didn't even have to time to mess with it again. When I get the chance I will look into your suggestion.

Thank you!

Tim

Tom Yum

Ok Tim, I got your solution.

I assumed you use the comment paid or unpaid for each student. If the student hasn't paid, you enter 'unpaid' and the conditional formatting will highlight the cell in red.

Here's a quick tutorial.

1. Go to Format on the menu bar.

2. Drop down to Conditional format.

3. In the box that opens up, select "Cell is not equal to" and in the blank next to it type in the value you want, such as 'unpaid' or you can use a dollar amount.

4. Click on the format button, go to patterns.

5. Click the color you want to pop up if the cell value is not equal to 'paid'

Hope this helps.

__________________

Love it, leave it or fix it.

Tim Mousel

Hi Tom,

Thanks for the help! I followed your tutorial and the column is changing color, however, I'd like it to be able check the column based on the date. As I have it now, it doesn't know which column to check for paid or unpaid.

I'm getting closer!

Thanks,

Tim

Hardball

use a formula starting with plus then the column ID for exampe +g34...that will tell it where to look.

__________________
The Way of the Warrior is Practice. Daily practice, accumulate practice minute by minute, hour by hour and day by day. {Book of 5 Rings} Mike Brewers 2008 Sit up challenge 29,000/100,000 running balance.(Crunches) Kicks 6,300/100,000