Excel VBA Select Case Loop Sub
- by Zack
In my excel file, I have a table setup with formulas.
with Cells from Range("B2:B12"), Range ("D2:D12"), and etc every other row containing the answers to these formulas.
for these cells (with the formula answers), I need to apply conditional formatting, but I have 7 conditions, so I've been using "select case" in VBA to change their interior…