Return to Question

I'd like to transfer this Excel spreadsheet to Google Sheets, maintaining the automatic background formatting functionality, particularly in the case of the borders.

Here is that spreadsheet within Google Sheets. It's running in Google Sheets in the .xlsx format, but the automatic borders are applied even if you "Save as Google Sheets".

I don't know how it works, but I see that somehow a slightly broken version of the automatic borders that are created in Excel are maintained in the transfer.

You can see how it's meant to function by opening it in Excel, but to describe the intended functionality: If you enter text into a cell in the "Cue Title" column, a number is added in the cell to the left (works correctly) and a border is applied to the top of that cell and down the range of the relevant columns. When uploading to Google Sheets, the border is applied two rows down instead.

How do I fix this?

I've attempted to manually apply borders, but I can't override existing automatic borders (which I don't want to override anyway). I've also tried Saving in the Google Sheets format and opening up Script Editor, but there's nothing there (that I could find). I'm stuck at this point.

I'd like to transfer this Excel spreadsheet to Google Sheets, maintaining the automatic background formatting functionality, particularly in the case of the borders.

Here is the same spreadsheet converted to a Google Sheet.

Excel applies the borders through conditional formatting, and they are somehow maintained in the transfer to the Google Sheets format, slightly broken.

You can see how it's meant to function by opening it in Excel, but to describe the intended functionality: If you enter text into a cell in Column B, a number is added in the cell to the left (works correctly) and a top border is applied to the cell through Column R. In Google Sheets, the border is applied two rows down instead.

How do I fix this?

The conditional formatting rule working in the background here is: Perhaps there is a clever way to edit this rule in Excel in order to make it translate properly to Google Sheets in the background?

I've tried changing the rule to =ISNUMBER($A$1), =ISNUMBER(A1), and Applies to: $B1:$R1, among other things. These only break the functionality further though.

I'd like to transfer this Excel spreadsheet to Google Sheets, maintaining the automatic background formatting functionality, particularly in the case of the borders.

Here is that spreadsheet within Google Sheets. It's running in Google Sheets in the .xlsx format, but the automatic borders are applied even if you "Save as Google Sheets".

I don't know how it works, but I see that somehow a slightly broken version of the automatic borders that are created in Excel are maintained in the transfer.

You can see how it functions by opening it in Excel, but to describe the intended functionality: If you enter text into a cell in the "Cue Title" column, a number is added in the cell to the left (works correctly) and a border is applied to the top of that cell and down the range of the white columns. When uploading to Google Sheets, the border is applied two rows down instead.

How do I fix this?

I've attempted to manually apply borders, but I can't override existing automatic borders (which I don't want to override anyway). I've also tried Saving in the Google Sheets format and opening up Script Editor, but there's nothing there (that I could find). I'm stuck at this point.

I'd like to transfer this Excel spreadsheet to Google Sheets, maintaining the automatic background formatting functionality, particularly in the case of the borders.

Here is that spreadsheet within Google Sheets. It's running in Google Sheets in the .xlsx format, but the automatic borders are applied even if you "Save as Google Sheets".

I don't know how it works, but I see that somehow a slightly broken version of the automatic borders that are created in Excel are maintained in the transfer.

You can see how it's meant to function by opening it in Excel, but to describe the intended functionality: If you enter text into a cell in the "Cue Title" column, a number is added in the cell to the left (works correctly) and a border is applied to the top of that cell and down the range of the relevant columns. When uploading to Google Sheets, the border is applied two rows down instead.

How do I fix this?

I've attempted to manually apply borders, but I can't override existing automatic borders (which I don't want to override anyway). I've also tried Saving in the Google Sheets format and opening up Script Editor, but there's nothing there (that I could find). I'm stuck at this point.

I'd like to transfer this Excel spreadsheet to Google Sheets, maintaining the automatic background formatting functionality, particularly in the case of the borders.

Here is that spreadsheet within Google Sheets. It's running in Google Sheets in the .xlsx format, but the automatic borders are applied even if you "Save as Google Sheets".

I don't know how it works, but I see that somehow a slightly broken version of the automatic borders that are created in Excel are maintained in the transfer.

You can see how it functions by opening it in Excel, but to describe the intended functionality: If you enter text into a cell in the "Cue Title" column, a number is added in the cell to the left (works correctly) and a border is applied to the top of that cell and down the range of the white columns. When uploading to Google Sheets, the border is applied two rows down instead.

How do I fix this?

I'd like to transfer this Excel spreadsheet to Google Sheets, maintaining the automatic background formatting functionality, particularly in the case of the borders.

Here is that spreadsheet within Google Sheets. It's running in Google Sheets in the .xlsx format, but the automatic borders are applied even if you "Save as Google Sheets".

I don't know how it works, but I see that somehow a slightly broken version of the automatic borders that are created in Excel are maintained in the transfer.

You can see how it functions by opening it in Excel, but to describe the intended functionality: If you enter text into a cell in the "Cue Title" column, a number is added in the cell to the left (works correctly) and a border is applied to the top of that cell and down the range of the white columns. When uploading to Google Sheets, the border is applied two rows down instead.

How do I fix this?

I've attempted to manually apply borders, but I can't override existing automatic borders (which I don't want to override anyway). I've also tried Saving in the Google Sheets format and opening up Script Editor, but there's nothing there (that I could find). I'm stuck at this point.