Someone please help me understand WHY this WORKS!?!?

[dml1783]

So i know typically people prob post with problems... well the only problem i have is I do not understand Why it works?

The formula is:
Code:

Please Login or Register  to view this content.

So what this does is, in the cell next to it, it is a drop down box, 1 star - 5 stars
when I select one of the options, the box with the formula above will auto change to an actual star(s).

So first there is the cell with the drop down to select the number of stars, then there are 5 cells next to it all with the formula above and as you select the number of stars the stars show up in the 5 cells...

What i'm hoping is someone can actually explain to me how it works and break down the code for me? I am glad it works but If i dont understand or learn what its doing i cant improve my skills.

I dont understand where or how the stars actually get called into play? Or really any bit of the code..

Please Help!!!

Capture.PNG

capture2.PNG

capture3.PNG

[AlphaFrog]

The formula is only half the story. The other half is the use of Conditional Formatting to display stars depending on the result of the formulas.

The formula itself extracts the left most character (1 to 5) from the selected value in the drop-down.

Then this explains how conditional formatting displays stars instead of the numbers.
Display Gold Star Icons in Excel with Conditional Formatting

[FDibbins]

Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).
http://www.mrexcel.com/forum/excel-q...why-works.html

[dml1783]

Thanks for the information. Although I did not really see what i was doing was wrong, after I read your article you gave me... I understand 100% how it would be frustrating to the people who do take there time out and try to resolve.

Thanks for the "Tip" and I will be careful of crossposting (or should i say NOT crossposting) in the future!

[FDibbins]

Thanks for the understanding

It's not that we dont want you to x-post (we cant really stop that anyway), just that you let us (and them) know when you do