Calculating Percentage of Attainment/Active

**littledragon** · 11-14-2007, 03:14 PM

I'm trying to build a spreadsheet to automatically calculate the percentage of active accounts. After the data entry of name, phone #, etc. is done on a line, the last field contains a drop down list for status 1) Active and 2) Inactive to select. (see attached)

Two questions:

1) Is there a way to attach a point value (Active =1 / Inactive=0) and total them at the bottom of the spreadsheet so that I can instantly see what percentage is active? My list is going to be about 500 items long, so I need to have this set up so that I can just open it, change someone's status and have it automatically update.

2) Is there a way to set up each status (Active/Inactive) to be color coded when you select that item in the drop down list (i.e. active=green and inactive=red)?

**BigBas** · 11-14-2007, 05:18 PM

1. You don't need to assign a point value per se. Just use a countif function, ie:

Please Login or Register  to view this content.

2. Use conditional formatting to color the cells accordingly. Go to FORMAT in the main toolbar, choose conditional format, and enter cell value is "Active" and choose green as your format. Do the same for inactive.