Link to home
Start Free TrialLog in
Avatar of Dave
DaveFlag for Afghanistan

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.
ASKER CERTIFIED SOLUTION
Avatar of barry houdini
barry houdini
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Dave

ASKER

Thanks!
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