Dave
asked on
From three numbers, highlight the lowest number if it is lower than the middle number by more than 5% of the middle number
Hello
Other than using a rather involved series of if statements is there a formula I can use to conditionally highlight the lowest number of three numbers if it is lower than the number with the middle value by more than 20% of the number with the middle value and also conditionally highlight the highest number if is higher than the number with the middle value by more than 20% of the number with the middle value?
For example in the attached sample file, 5 would be highlighted in the first set of numbers (13 is the middle number) and both 10 and 35 would be highlighted in the second set of numbers (25 is the middle number).
Thanks for your help
C--Users-Dave-OneDrive-Documents-sample.
Other than using a rather involved series of if statements is there a formula I can use to conditionally highlight the lowest number of three numbers if it is lower than the number with the middle value by more than 20% of the number with the middle value and also conditionally highlight the highest number if is higher than the number with the middle value by more than 20% of the number with the middle value?
For example in the attached sample file, 5 would be highlighted in the first set of numbers (13 is the middle number) and both 10 and 35 would be highlighted in the second set of numbers (25 is the middle number).
Thanks for your help
C--Users-Dave-OneDrive-Documents-sample.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks!
This works great.
I had opened excel 2013 and thought I had saved it as the default excel workbook.
This works great.
I had opened excel 2013 and thought I had saved it as the default excel workbook.
No problem,
Thanks Dave and David!
regards, barry
Thanks Dave and David!
regards, barry
Sample.xlsx