Side note: Wasn't aware you can't upload *.ods. Can I e-mail this to somebody that wants to mess with it?
Open Office
Started by
Shady
, Jan 11 2009 08:53 AM
#1
Posted 11 January 2009 - 08:53 AM
Side note: Wasn't aware you can't upload *.ods. Can I e-mail this to somebody that wants to mess with it?
#2
Posted 11 January 2009 - 10:08 AM
Can you add an extra "high score" line?
As an example, let's say your data is Scores in B2 to B10 and Names in C2 to C10.
In A1, you put "Highest Score is:"
In B1, = max(B2:B10)
In C1, =vlookup(B1,B2:C10,2,false)
As an example, let's say your data is Scores in B2 to B10 and Names in C2 to C10.
In A1, you put "Highest Score is:"
In B1, = max(B2:B10)
In C1, =vlookup(B1,B2:C10,2,false)
#3
Posted 12 January 2009 - 12:46 PM
ive got a line that does that. i want it to highlight (as in background color) the highest score. im just checking in real quick, but ill try and get a screen shot of the file sometime tonight or tomorrow to get a better understanding.
#4
Posted 13 January 2009 - 03:03 PM
cant seem to get print screen to work.
#5
Posted 13 January 2009 - 04:13 PM
To highlight the cell with the highest score...
Can you add an extra "high score" line?
As an example, let's say your data is Scores in B2 to B10 and Names in C2 to C10.
In A1, you put "Highest Score is:"
In B1, = max(B2:B10)
In C1, =vlookup(B1,B2:C10,2,false)
Then highlight the scores B2 to B10 and click Format > Conditional Format...
Condition 1: Cell Value is 'Equal to' > click in the next empty box then click on B1 so that =$B$1 appears
Click the Format button, Patterns, and select the background colour, OK, OK
Can you add an extra "high score" line?
As an example, let's say your data is Scores in B2 to B10 and Names in C2 to C10.
In A1, you put "Highest Score is:"
In B1, = max(B2:B10)
In C1, =vlookup(B1,B2:C10,2,false)
Then highlight the scores B2 to B10 and click Format > Conditional Format...
Condition 1: Cell Value is 'Equal to' > click in the next empty box then click on B1 so that =$B$1 appears
Click the Format button, Patterns, and select the background colour, OK, OK
Similar Topics
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users