Sure, apologies for the lack of clarity. The gist is that a spreasheet is being populated by conditionally bringing in data from a root worksheet if formulas are met.
- In the row where the formula is met, columns A thru I will be populated with data (columns A and B being numbers and C thru I are text data).
- In the rows where the formula is not met, columns A thru I are populated "" placeholders.
My goal is to border the cells of only those rows in which the formula is met. Ex:
..................A.....................B......................C......................D
Row1:....123456............1......................data...............data
Row 2: .....""....................."".......................""....................""
Row 3:...123456............1......................data...............data
I would want the cells of Rows 1 and 3 outlined and row 2 ignored and tried using a formula to validate the first column of each row as containing 6-digits: Thus return of 6-digitis equals success and outlining, whilst return of "" (or NOT 6 digits equals fail and no outlining)
Bookmarks