thbutterflycollector_
New Member
- Joined
- Oct 29, 2015
- Messages
- 42
- Office Version
- 365
- Platform
- Windows
Hi,
I am trying to apply an formula to highlight prices in Columns G, L and Q that are outside +/- a stated percentage of the average value for that price:
The % in T1 should be such that it can be manually changed and the conditional formatting updates accordingly. Any solutions appreciated.
I am trying to apply an formula to highlight prices in Columns G, L and Q that are outside +/- a stated percentage of the average value for that price:
Column G | Column L | Column Q | Column T | |
---|---|---|---|---|
Row 1 | 10% | |||
Row 2 | A | B | C | Median/Average |
Row 3 - Nuts | 31 | 42 | 32 | 35 |
Row 4 - Bolts | 11 | 9 | 7 | 9 |
The % in T1 should be such that it can be manually changed and the conditional formatting updates accordingly. Any solutions appreciated.
