Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-12-2017, 07:41 PM
clayg clayg is offline Looking for Conditional Formatting help! Windows 10 Looking for Conditional Formatting help! Office 2016
Novice
Looking for Conditional Formatting help!
 
Join Date: Oct 2017
Posts: 1
clayg is on a distinguished road
Default 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
Attached Files
File Type: xlsm 10-ScoreSheet-Test i.xlsm (35.4 KB, 13 views)
Reply With Quote
Reply

Thread Tools
Display Modes


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
Looking for Conditional Formatting help! Conditional formatting technofrank Excel 3 06-08-2015 03:15 AM
Looking for Conditional Formatting help! 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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:13 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft