Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Open Office


  • Please log in to reply

#1
Shady

Shady

    Member

  • Member
  • PipPipPip
  • 193 posts
Greetings. I didn't know where else to turn for my "problem," so I came here. You guys have yet to fail me. Anyway, the attached file is what I need help with. I bowl in a league and we use this file as an easy way to keep track of payouts (vs paper). What we would like to do (so it's automatic) is have OpenOffice automatically highlight the HIGHEST score in each of the 4 games and series. Also, if possible, have it automatically highlight the LOWEST scores in the "Doubles Results" column. I can't figure out how to do it, or if it's even possible. Thank you guys for all the help.

Side note: Wasn't aware you can't upload *.ods. Can I e-mail this to somebody that wants to mess with it?
  • 0

Advertisements


#2
Vino Rosso

Vino Rosso

    Visiting Staff

  • Visiting Consultant
  • 235 posts
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)
  • 0

#3
Shady

Shady

    Member

  • Topic Starter
  • Member
  • PipPipPip
  • 193 posts
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.
  • 0

#4
Shady

Shady

    Member

  • Topic Starter
  • Member
  • PipPipPip
  • 193 posts
cant seem to get print screen to work.
  • 0

#5
Vino Rosso

Vino Rosso

    Visiting Staff

  • Visiting Consultant
  • 235 posts
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
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP