Hello,
I have some existing excel files that are generated from Access. How would I go about formatting the worksheets of these workbooks based on a string that appears in a row?
For example, I would like to have the range of cells (A:G) for each worksheet in each workbook, highlighted in yellow with top and bottom borders, but only for the rows where the contents in column A contain the string "Hours Variance".
There are several workbooks each containing several tabs and my existing modules have been generated in Access. Thanks.
I have some existing excel files that are generated from Access. How would I go about formatting the worksheets of these workbooks based on a string that appears in a row?
For example, I would like to have the range of cells (A:G) for each worksheet in each workbook, highlighted in yellow with top and bottom borders, but only for the rows where the contents in column A contain the string "Hours Variance".
There are several workbooks each containing several tabs and my existing modules have been generated in Access. Thanks.