Thread: Help a newb....
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
gibson00 gibson00 is offline
external usenet poster
 
Posts: 1
Default 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!!!!!!!!!!!!!!!!!!!!


--
gibson00
------------------------------------------------------------------------
gibson00's Profile: http://www.excelforum.com/member.php...o&userid=36231
View this thread: http://www.excelforum.com/showthread...hreadid=560168