Sorry if this is the wrong forum, wasn't sure which would be best. I am trying to complete a spreadsheet for work, and am a complete excel rookie. I'd -really- appreciate some help. I'm sure these are basic questions for you guys/gals:

We are tracking some metrics in a spreadsheet. In the cells where I have the scores, I would like to:
1. Next to the actual score, have the percentage value of the score show as well. So if their score was 10 out of 20 (the 20 value is in a cell above as a numeric title, so can reference that), I want '50%' to show next to the 10 value. Maybe I need to create an extra column next to the scores? Or can it be shown in the same cell?

2. If the score is below a certain value percentage, like 50, I'd like the cell to highlight red.

Thanks!!!!!!!!!!!!!!!!!!!!