tstout1000
New Member
- Joined
- Jan 26, 2022
- Messages
- 11
- Office Version
- 365
- Platform
- Windows
I have an array (example below). I want to be able to highlight via conditional formatting using a Cell Reference (below N3) and range (below 5).
I have inputs that I can change the Cell Reference and Range, Example: Cell Reference = Q3 and Range = 9.
I can easily highlight the ending cell using format using a formula =CELL("address",B2)=$D$4 with $D$4 being the location of my input (e.g. Q3).
But I also want to highlight the preceding values dynamically (e.g. above the 8 previous columns).
Any help greatly appreciated.
I have inputs that I can change the Cell Reference and Range, Example: Cell Reference = Q3 and Range = 9.
I can easily highlight the ending cell using format using a formula =CELL("address",B2)=$D$4 with $D$4 being the location of my input (e.g. Q3).
But I also want to highlight the preceding values dynamically (e.g. above the 8 previous columns).
Any help greatly appreciated.