Horse Racing Forum - PaceAdvantage.Com - Horse Racing Message Board

Go Back   Horse Racing Forum - PaceAdvantage.Com - Horse Racing Message Board > Off Topic > Off Topic - Computers


Reply
 
Thread Tools Rate Thread
Old 01-16-2019, 08:53 PM   #1
gfnut
Registered User
 
Join Date: Jan 2006
Location: Long Beach, Ca.
Posts: 363
Excel Help!

I am trying to color the 3 highest #'s and ties in each column at the touch of a button. Can I do this with custom formatting or do I have to write a macro? Any help would be appreciated.


Grid.PNG
gfnut is offline   Reply With Quote Reply
Old 01-16-2019, 09:40 PM   #2
barn32
tmrpots
 
barn32's Avatar
 
Join Date: Jun 2008
Posts: 2,285
Quote:
Originally Posted by gfnut View Post
I am trying to color the 3 highest #'s and ties in each column at the touch of a button. Can I do this with custom formatting or do I have to write a macro? Any help would be appreciated.


Attachment 23843
Google Docs is very similar to Excel, so using conditional formatting in my Google Docs spreadsheet I used this custom formula to highlight the largest value in a column:

=H6=LARGE($H$6:$H$25,1)

1. Highlight the column
2. Select conditional formatting
3. Custom formula
4. Enter formula
5. Select a color
6. Create a new rule and repeat with the second formula for the next highest value

Change the 1 at the end to a two, add a new rule, and you will get the second largest value:

=H6=LARGE($H$6:$H$25,2)

If your data starts in say, cell H1 then change the H6 to H1. In my spreadsheet I had some headers so I started at H6.

If that formula doesn't work try this one:

=LARGE($H$6:$H$25,1)

Link
barn32 is offline   Reply With Quote Reply
Old 01-16-2019, 10:58 PM   #3
gfnut
Registered User
 
Join Date: Jan 2006
Location: Long Beach, Ca.
Posts: 363
Thanks for the info. I will give it a try.
gfnut is offline   Reply With Quote Reply
Old 01-16-2019, 10:58 PM   #4
mikesal57
Veteran
 
mikesal57's Avatar
 
Join Date: Sep 2003
Location: NEW YORK CITY
Posts: 3,670
Quote:
Originally Posted by gfnut View Post
I am trying to color the 3 highest #'s and ties in each column at the touch of a button. Can I do this with custom formatting or do I have to write a macro? Any help would be appreciated.


Attachment 23843
HIGH-LIGHT your rows..

Choose Conditional Formatting....

Choose Highlight Cell Rules---EQUAL TO

Then do this for 1-2-3 seperatly

Attached Images
File Type: jpg Capture.JPG (123.6 KB, 26 views)
mikesal57 is offline   Reply With Quote Reply
Old 01-23-2019, 11:32 AM   #5
hracingplyr
Registered User
 
Join Date: Mar 2001
Posts: 403
Windscribe

Whats the group's opinion on this?

Bob
hracingplyr is offline   Reply With Quote Reply
Reply




Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

» Advertisement
Powered by vBadvanced CMPS v3.2.3

All times are GMT -4. The time now is 07:52 AM.


Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Copyright 1999 - 2023 -- PaceAdvantage.Com -- All Rights Reserved
We are a participant in the Amazon Services LLC Associates Program, an affiliate advertising program
designed to provide a means for us to earn fees by linking to Amazon.com and affiliated sites.