I realize the easiest thing to do is to use conditional formatting, however in this case it won’t work quite so easy!
I am creating new worksheets from a third party program, so the standard CF won’t work. Starting on Row 14: E14, will have data, then E16 could, or it may not have information until E21. The worksheet is dynamic, with as many as 70 lines, and I would like to have a top border applied to the entire row only if a cell in Column E has data in it. (Should mention that the cell is merged with D,E, & F)
Is there such a thing a a macro to apply conditional formats?
I am currently storing all macros on a background workbook, then applying them to the new one.
Am I way out in left field for what I’m asking?
Thanks
Bookmarks