emirmansouri
New member
- Joined
- Nov 17, 2013
- Messages
- 1
- Reaction score
- 0
- Points
- 0
I would like to add to my existing worksheet change event a code that will format a Range (A9:BM50000)
if cell in Column A is not blank then apply a normal thin border around that row and center the contents.
Example
A9 is not blank, apply the border from A9:BM9 & center the contents of the cells
if it is blank do nothing.
If someone could get this integrated with my code it would be greatly appreciated.
Here is a link to my thread on MrExcel
mrexcel.com/forum/excel-questions/739852-visual-basic-applications-conditional-formatting-borders-worksheet-change-event.html
if cell in Column A is not blank then apply a normal thin border around that row and center the contents.
Example
A9 is not blank, apply the border from A9:BM9 & center the contents of the cells
if it is blank do nothing.
If someone could get this integrated with my code it would be greatly appreciated.
Here is a link to my thread on MrExcel
mrexcel.com/forum/excel-questions/739852-visual-basic-applications-conditional-formatting-borders-worksheet-change-event.html