#1
|
|||
|
|||
Looking for Conditional Formatting help!
I have attached an excel file that I have been working on. This is a golf scoresheet for points. It averages the top 2,3,4,5,6, numbers in a row. I throw out the highest number and the four lowest numbers. Calculations all seem to work fine.
Problem is conditional formatting. The highlighted red number is the highest number which is not used in calculation. The highlighted green numbers are the numbers used The highlight black numbers are the bottom 4 (7,8,9,10) which are also not used in calculation. When a golfer has multiple scores that are the same, CF will not distinguish between green and black highlights. Note highlighted golfers. Sheet should see High number first then green numbers and then the lowest numbers in black. Thanks |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Need help with conditional formatting | mikehk | Excel | 6 | 09-22-2017 11:20 PM |
Help with if and conditional formatting | piper7971 | Excel | 11 | 06-10-2015 12:07 AM |
Conditional formatting | technofrank | Excel | 3 | 06-08-2015 03:15 AM |
Conditional formatting that ignores other formatting rules | info_guy2 | Excel | 1 | 07-03-2014 10:07 AM |
conditional formatting | otuatail | Excel | 1 | 06-06-2012 05:07 AM |