I have the following table. For each row, I would like it to highlight the cell if the column header (E) is greater than or equal to the value in Column C and if it is less than or equal to the value in Column D.
For instance, if we looked at Apartment Investment Advisers, E3 would have no highlight, F3 would, G3 would, H3 would.
For instance, if we looked at Apartment Investment Advisers, E3 would have no highlight, F3 would, G3 would, H3 would.
Impress Usage.xlsx | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
1 | Subscription | |||||||||
2 | Customer | Sales Rep | Month | 15th Month | 2020/10 | 2020/11 | 2020/12 | 2021/01 | ||
3 | APARTMENT INVESTMENT ADVISERS | Bryan Schweet | 2020/11 | 2022/01 | $ - | $ - | $ 539.85 | $ 2,004.75 | ||
4 | BROWN & BROWN OF OHIO LLC | Randy Ratliff | 2020/10 | 2021/12 | $ - | $ 144.25 | $ 395.23 | $ 550.29 | ||
5 | CITY OF LEON VALLEY | Eddie Lopez | 2020/10 | 2021/12 | $ - | $ - | $ 12.50 | $ 49.97 | ||
6 | GOOD KARMA BROADCASTING LLC | Tamera Dodge | 2020/11 | 2022/01 | $ - | $ - | $ 339.55 | $ 276.57 | ||
7 | INDIANA LOGO SIGN GROUP | Wallace Sisemore | 2020/10 | 2021/12 | $ - | $ 36.48 | $ 197.60 | $ 189.22 | ||
8 | IRALOGIX INC | Marilyn Shaffer | 2020/10 | 2021/12 | $ - | $ 9,878.90 | $ 764.70 | $ 923.27 | ||
9 | LEADER PRINTING AND MAILING LLC | Stephen Havens | 2020/10 | 2021/12 | $ - | $ 0.12 | $ - | $ - | ||
10 | MFI CREDIT SOLUTIONS LLC | Kevin Moody | 2020/10 | 2021/12 | $ 2.01 | $ 3,959.78 | $ 2,851.78 | $ 5,917.24 | ||
11 | NEW DREAMS INC | Stephen Havens | 2020/12 | 2022/02 | $ - | $ - | $ 114.56 | $ 119.25 | ||
12 | PRECISION RISK MANAGEMENT | Mark Sohn | 2020/10 | 2021/12 | $ - | $ - | $ - | $ 2,484.22 | ||
13 | R I LAMPUS COMPANY | Amanda Davis | 2020/09 | 2021/11 | $ 0.08 | $ 227.90 | $ 160.16 | $ 117.86 | ||
14 | REPSOL OIL & GAS USA LLC | Marilyn Shaffer | 2020/11 | 2022/01 | $ - | $ - | $ - | $ 0.36 | ||
15 | SBC WASTE SOLUTIONS | Bryan Schweet | 2020/12 | 2022/02 | $ - | $ - | $ 109.42 | $ 637.64 | ||
16 | STAMPER & COMPANY INC | Stephen Havens | 2020/12 | 2022/02 | $ - | $ - | $ - | $ 0.74 | ||
17 | TEXAS DISPOSAL SYSTEMS | Peter Soto | 2020/10 | 2021/12 | $ - | $ - | $ - | $ 0.18 | ||
18 | ||||||||||
19 | $ 2.09 | $ 14,247.43 | $ 5,485.35 | $ 13,271.56 | ||||||
Main |
Cell Formulas | ||
---|---|---|
Range | Formula | |
D3:D17 | D3 | =EDATE(C3,14) |
E3:H17 | E3 | =VLOOKUP($A3,Pivot!$A:$T,COLUMNS(Pivot!$A:B)+1,0) |
E19:H19 | E19 | =SUM(E3:E18) |