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!!!!!!!!!!!!!!!!!!!!
--
gibson00
------------------------------------------------------------------------
gibson00's Profile:
http://www.excelforum.com/member.php...o&userid=36231
View this thread:
http://www.excelforum.com/showthread...hreadid=560168