MasterOfDisaster
Board Regular
- Joined
- Dec 19, 2007
- Messages
- 70
The title is not very descriptive, I realize. I need to highlight the whole row of a range based on its row number denoted in a given cell.
So for example, if my range is D5:K10 and the value in cell A1 is 3, I need to highlight the whole second row of the range (that is D7:K7). If A1 is 6 then range D10:K10 should be highlighted.
Either a conditional format or a macro solution would work, the preference is for the former.
Thanks in advance.
So for example, if my range is D5:K10 and the value in cell A1 is 3, I need to highlight the whole second row of the range (that is D7:K7). If A1 is 6 then range D10:K10 should be highlighted.
Either a conditional format or a macro solution would work, the preference is for the former.
Thanks in advance.