Help a newb....

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!!!!!!!!!!!!!!!!!!!!

Originally Posted by MartinShort

I'm going to make some assumptions here.

A1=10
B1=20

So to get the percentage, in C1 type "=A1/B1" and then click the % button on formatting toolbar at the top of the page.

To get the cell to change colour, have a look at http://www.excelforum.com/showthread.php?t=560169

Thanks for the reply.
I do know how to calculate the percent, but was wondering if there was a way to show both the actual score, and the percent, in the same cell.
So if the metric/test were out of 20, and they scored a 10, I'd want the cell to read:
10 (50%)

Is that possible?

Thanks!

OK, I can get the highlighting to work for a single cell, and possibly a single column, but I can't seem to highlight all the scores and insert one formula to handle them all, ASSUMING that all the scores are not out of 20, so they each need to reference their own 'out of' score....