how to add empty rows in the excel

nitish_2001

i want to add rows at 5 or 6
and i want to color the whole row but if the content is there then background color applies
if content in the cell not there then the color is not applied
https://codepen.io/Nitish-procoder/pen/dyVGOMK

kthorngren

Use columns.createdRow to apply row styling based on the row data. See this example.

Kevin

nitish_2001

it specifies single cell and i want whole row with background color in excel

colin

I explained how to do that in one of your many other minimal threads.

Colin