LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default counting cells in a row with color highlight

I am new to doing this program so if i sound dumb sorry. if you know golf
this might be simple to understand. i have several rows with names and 18
colums ( 1 for each 18 holes). I am trying to do a count of skins won by each
player at the end of each players row.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
18
name 1 4 5 4 6 3 4 5 5 5 5 6 4 6 4 4 4 4
4
name 2 4 4 4 4 4 4 4 4 4 3 3 5 5 5 5 5 5
5
name 3 3 4 4 4 3 5 5 5 5 4 5 5 5 5 5 4 4
3
name 4 4 4 4 4 4 4 3 5 5 5 5 5 5 5 3 4 4
5

I have the sheet set to highlight the lowest value in each column if there
is only one lowest value. here is where it gets confusing. if there is more
than on low value then it would carry over to the next column until it comes
to a column with only one
highlighted. here is what the total would be in the ex. at the end of each
row.
name 1 total is 3
name 2 total is 4
name 3 total is 4
name 4 total is 7

I am mostly doing this just to learn excel but it will also make it easier
for my little golfing group to figure the the winners.

thanks for any direction.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
highlight color in cells lacy New Users to Excel 7 June 17th 08 02:59 PM
How do I change highlight color of selected cells Suz Excel Discussion (Misc queries) 2 November 7th 07 01:25 AM
how do I change the highlight color of selected cells in Excel david a carmody Excel Discussion (Misc queries) 0 April 25th 07 06:14 PM
change highlight color on active cells Louis New Users to Excel 1 November 22nd 05 08:43 PM
highlight/color cells with specific character inside markx Excel Worksheet Functions 6 October 20th 05 10:19 AM


All times are GMT +1. The time now is 12:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"