CharloskyD
New Member
- Joined
- Apr 5, 2022
- Messages
- 1
- Office Version
- 2019
- Platform
- Windows
I have 3 columns with data, they are not in order. Row has amount and one can see the highest, middle and least. Below it i have 3 percentages as well, not in order but you can tell the largest, middle and smallest. Assuming columns are A, B and C and my rows are from 2 to 3. Last row being blank..
What i have been able to do
1. Add Conditional format to identify the highest % in row 2.
2. Add conditonal format to identify the amount in row 1 that correspond to the highest percentage identified in row 2 - i used index and match.
My problem.
I need a dynamic formular. That meets the following conditions.
a) if amount identified with second formular is the highest, i need second highest amount hightlighted
b) if amount identified with second formular is the middle amount, i need the highest amount highlighted
c) if the amount identified with the second formular is the least amount, i need the middle amount highlighted
What i have been able to do
1. Add Conditional format to identify the highest % in row 2.
2. Add conditonal format to identify the amount in row 1 that correspond to the highest percentage identified in row 2 - i used index and match.
My problem.
I need a dynamic formular. That meets the following conditions.
a) if amount identified with second formular is the highest, i need second highest amount hightlighted
b) if amount identified with second formular is the middle amount, i need the highest amount highlighted
c) if the amount identified with the second formular is the least amount, i need the middle amount highlighted