Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
excel newb needs some help making multiple sheets communicate for ecommerce project! | Excel Discussion (Misc queries) | |||
i know this has to be so easy -newb | Excel Discussion (Misc queries) |