hi
Is there an easy way with vba coding, that when the active cell is in range D11:I20, the active row - limited to that range [i.e active row, col D-I], will be: 1. highlighted with a cell back colour, 2. the writing be set to bold and 3. for that entire row in that range to be surrounded by a thick border.
Important though is that once active cell changes [either by moving to a different row in range, or by leaving that range entirely], the properties all revert back to how they were originally.
Any help would be greatly appreciated.
Is there an easy way with vba coding, that when the active cell is in range D11:I20, the active row - limited to that range [i.e active row, col D-I], will be: 1. highlighted with a cell back colour, 2. the writing be set to bold and 3. for that entire row in that range to be surrounded by a thick border.
Important though is that once active cell changes [either by moving to a different row in range, or by leaving that range entirely], the properties all revert back to how they were originally.
Any help would be greatly appreciated.