How do I write a Macro for Conditional Formatting code to get Borders?
I want to create a sheet with a Macro and I want to create simple borders around the Cells uptill the last filled cell.
Ex: Data is from Col A till Col K
If there data in the column B then there should be borders around the entire ROW from Col A till Col K.
This whole sheet will be devoid of GridLines and therefore the only borders present will be due to the conditional formatting or if there's any other way of making.
So Any ideas..!
Warm regards
e4excel
Bookmarks