Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Prevent inheriting formatting from previous row.

Jamison ✭✭✭✭✭
edited 12/09/19 in Archived 2016 Posts

I have a sheet where the first row is populated with instructions on how to complete each column (becasue the column title text is so limited - but i digress).


That row is formatted in a green color to set it off from the actual data rows.  The problem is, when I go to enter data in the next row (2), that row automatically changes to the above row's green color.


As i type this, I realize i can do a conditional formatting rule that sets the format to "no fill" when the primary column is empty or populated, but I'd rather not have to do that.


Any ideas? 


This discussion has been closed.