how to add empty rows in the excel
how to add empty rows in the excel

in General
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
This question has an accepted answers - jump to answer
This discussion has been closed.
Answers
Use
columns.createdRow
to apply row styling based on the row data. See this example.Kevin
it specifies single cell and i want whole row with background color in excel
I explained how to do that in one of your many other minimal threads.
Colin