Help with spreadsheet to track membership dues...

[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

[Hardball]

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

[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.

[Tom Yum]

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

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.

[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]

Outsourcing

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.

[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.

[Aynesworth]

Thanks Hardball.....I have applied the formula and got the required results. The problem is resolved. Thanks to this forum members.
Regards...