Adding 5 star rating system

I don't think you would be able to do that. There is an easy way and a hard way to approximate what you want.

EASY WAY:

Let Column A be the movie title, Column B be blank, and Column C have your stars. Format Column C to have yellow text in Wingdings font.

In Column C, put in this formula:

IF(B=1,"X",IF(B=2,"XX",IF(B=3,"XXX",IF(B=4,"XXXX",IF(B=5,"XXXX","ERROR")))))

"X" has to be whatever letter or number in Wingdings makes the star. I don't know what it is off the top of my head.

So if a user puts in "3" in Column B, 3 stars will appear in Column C. If a user puts in any value other than 1, 2, 3, 4, or 5, it will return the message "ERROR".

HARD WAY:

You can look up how to do custom icon sets in Excel. I have never tried doing this.

=REPT("X",B1) is slightly shorter if you choose that method

You can use Conditional Formatting for this. It wont give you stars, but you can set it up to give you bars.

1. Highlight the range you want to apply the CF 2
2. select CF on the home tab/styles
3. click New Rule/format cells cells that contain
4. click Format Style, select Icon Sets
5. click Icon Style (at the bottom), select 5 ratings
6. change the TYPE from Percent to number
7. in VALUE, enter 5, 4, 3, 2 respectively in each block

You can elect to not see the value, if you want

Col A = Name of Song
Put this in the sheet's code module. Double click on a cell to rank that row's song.
Change the column widths, font and the X,O to suit your visual desires.

Please Login or Register  to view this content.