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
|