Data Shuttle Formatting

GM185220 · 02/10/25

When using replace in Data shuttle to update a sheet. The rows are now appearing in black. Has anyone seen this and knows how to fix?

Paul Newcome · 02/10/25

Ok. What happens if you select all of the column headers and then click the button to remove all formatting:

Paul Newcome · 02/10/25

Do you have any conditional formatting on the sheet?

GM185220 · 02/10/25

Hi Paul - no conditional formatting on sheet

Paul Newcome · 02/10/25

Ok. What happens if you select all of the column headers and then click the button to remove all formatting:

GM185220 · 02/10/25

Yes that works - I will check if this happens again not sure why it changed but at least I have a solution thanks again

Paul Newcome · 02/10/25

If there was formatting on an existing row when the Data Shuttle created all of the new rows, the formatting could have been automatically applied.

GM185220 · 02/10/25

Great thanks again :-)

Paul Newcome · 02/10/25

Happy to help. 👍️

Best Answer