Hello, I am looking to highlight any cells Green that have at equal or greater of 5% increase from previous month. Then I am looking to highlight any cells Red that have a decrease of 5% of previous month. Below is a sample of using the Mini Sheet option as well as a screenshot. The Column "Charges" starts on A4. Thanks!
FY 2022 - Bill Wright.xlsx | ||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | |||
4 | Charges | Jan-21 | Feb-21 | Mar-21 | Apr-21 | May-21 | Jun-21 | Jul-21 | Aug-21 | Sep-21 | Oct-21 | Nov-21 | Dec-21 | Jan-22 | Feb-22 | Mar-22 | Apr-22 | May-22 | Jun-22 | Total | ||
5 | 411 | 2.50 | - | 1.50 | 0.50 | 2.00 | 2.50 | - | 1.50 | 0.50 | 1.50 | - | - | - | - | - | - | - | - | 12.50 | ||
6 | 411 LIST | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||
7 | ACT-800TFN | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||
8 | ACT-DID | 4.00 | 12.00 | 21.00 | 5.50 | 2.50 | 8.50 | 8.75 | 12.25 | 8.00 | 20.25 | - | - | - | - | - | - | - | - | 102.75 | ||
9 | ACT-DID800 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||
10 | ACT-DIDINTL | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||
11 | CHARGEBACK FEE | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||
12 | CNAM | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||
13 | CNAM - PER CALL | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||
14 | CNAM-PER TN | 624.29 | 631.86 | 640.50 | 633.89 | 617.30 | 490.08 | 494.98 | 485.35 | 486.43 | 485.23 | - | - | - | - | - | - | - | - | 5,589.91 | ||
15 | CPAAS TERM | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||
Summary By Customer |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B5:S15 | B5 | =SUMIFS(Summary!G:G,Summary!$C:$C,'Summary By Customer'!$A$2,Summary!$E:$E,'Summary By Customer'!$A$5:$A$119) |
T5:T15 | T5 | =SUM(Table5[@[Jan-21]:[Jun-22]]) |
Named Ranges | ||
---|---|---|
Name | Refers To | Cells |
_1_POINT_COMMUNICATIONS_9512 | ='Summary By Customer'!$A$2 | B5:S15 |
Customers | ='Summary By Customer'!$A$2 | B5:S15 |