I want the formatting of columns G and H to look like G4 and H4 (for example), but the new form submissions are coming in looking like G7 and H7 (for example). How can I remedy this?
I want the formatting of columns G and H to look like G4 and H4 (for example), but the new form submissions are coming in looking like G7 and H7 (for example). How can I remedy this?
for font color, no-underline, and cell background color you need to use conditional formatting because submissions are added as new rows (not into existing rows)
for alignment of text try to select the whole column by clicking on column latter and format it as you wish