I have a table where the first column is a date array that fills from a selected a start date to (in effect) the current month. Hence, each month the number of elements in the array extend down the rows.
From that column I then use array formulae to "spill down" calculated values based on each row's date for a number of fields.
What I would like to have is ALL the cell formatting "spill" down for each column as well. I've set the format of the column set so that numbers, [$.c] amounts, text etc are formatted as required for the entire column, but I cannot get cell formatting for borders etc to replicate downward. Means I have to manually format the cell borders as the array rows extend each month.
My question:
From that column I then use array formulae to "spill down" calculated values based on each row's date for a number of fields.
What I would like to have is ALL the cell formatting "spill" down for each column as well. I've set the format of the column set so that numbers, [$.c] amounts, text etc are formatted as required for the entire column, but I cannot get cell formatting for borders etc to replicate downward. Means I have to manually format the cell borders as the array rows extend each month.
PS: I don't want to see this border formatting flow down beyond the end of the array row.
My question:
- Is there a way to get border formatting to occur for the rows with the array in it, but to *not* show below the 'table' of data.
- Or do I just have to use conditional formatting to achieve it?
e.g. conditional formatting borders etc based on something along these lines - -
Excel Formula:
AND( row( A1 ) > row( A$5 ) , row(A1) <= count( A$5# ) + row( A$5 ) )
