Google Answers Logo
View Question
 
Q: Spreadsheet Query - Microsoft Works 6.0 Spreadsheet or Excel ( Answered 4 out of 5 stars,   0 Comments )
Question  
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.
Answer  
Subject: Re: Spreadsheet Query - Microsoft Works 6.0 Spreadsheet or Excel
Answered By: omnivorous-ga on 11 Mar 2004 09:23 PST
Rated:4 out of 5 stars
 
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:4 out of 5 stars
Thankyou for fast answer.  If Conditional Formatting is what I need to
get the cells bold, then it looks like I need Excel.

Comments  
There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

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 Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy