Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel newb needs some help making multiple sheets communicate for ecommerce project! ebay801 Excel Discussion (Misc queries) 1 January 13th 06 04:38 AM
i know this has to be so easy -newb chris_ Excel Discussion (Misc queries) 6 July 11th 05 09:57 PM


All times are GMT +1. The time now is 02:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"