![]() |
|
![]() | ||
|
Subject:
Spreadsheet Query - Microsoft Works 6.0 Spreadsheet or Excel
Category: Computers > Programming Asked by: thickster-ga List Price: $5.00 |
Posted:
11 Mar 2004 07:11 PST
Expires: 10 Apr 2004 08:11 PDT Question ID: 315720 |
I need to perform some spreadsheet calculations. I have MS Works 6.0 Spreadsheet, but can't find an appropriate function and think I may need Excel to do this. For a row, I want to select the highest value in a row and enter that in a cell at the end of the row - in the example below,in row 1 = 6.6. Ideally, I would also like to make the highest value bold (in columns 1 - 4) 6.2 6.1 6.3 6.6 6.6 5.1 5.9 5.5 5.5 5.9 2.3 2.7 2.8 2.4 2.8 1.2 1.1 0.9 1.3 1.3 In short, how can I do this in MS Works 6.0 Spreadsheet, or, if I need Excel, how would I do it in Excel. |
![]() | ||
|
Subject:
Re: Spreadsheet Query - Microsoft Works 6.0 Spreadsheet or Excel
Answered By: omnivorous-ga on 11 Mar 2004 09:23 PST Rated: ![]() |
Thickster -- Excel has supported a MAX function at least since Excel 2000. It allows you do select the maximum value from a range. I've entered your values in a very simple spreadsheet here: http://www.mooneyevents.com/thick.xls The formula for picking out the maximum value is: =MAX(A2:D2) where we've put each of your values in the rows A2:D2 and A3:D3 and A4:D4 and A5:D5 BOLD FORMAT ---------------------- Conditional formatting can be handled in two ways: a Visual Basic script or by using the spreadsheet's Format/Conditional Formatting Command. The former means writing VBA code; the latter can be done from the menu system but has to be created line-by-line: 1. Go to Format/Conditional Formatting 2. Enter: "cell value is" and "greater than or equal to" 3. in the third pane enter: =MAX(A2:D2) or each appropriate row 4. choose your boldface with the Format button 5. click OK Google search strategy: "Excel functions" + "conditional formatting" I don't have a copy of Microsoft Works, but his Microsoft Knowledge Base article indicates that Works DOES have the MAX function: Microsoft Knowledge Base "Works for Windows Spreadsheet Functions" http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q137/0/77.asp&NoWebContent=1 Best regards, Omnivorous-GA |
thickster-ga
rated this answer:![]() Thankyou for fast answer. If Conditional Formatting is what I need to get the cells bold, then it looks like I need Excel. |
![]() | ||
|
There are no comments at this time. |
If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you. |
Search Google Answers for |
Google Home - Answers FAQ - Terms of Service - Privacy Policy |