Cell Highlights Automatically

I'm using the Event Planning with Budget template. Whenever I add a new row, then type in text in that row, it automatically highlights specific cells in that row a grey color. Even though the row above and the row below are highlighted in white and initially the new row is white. How do I stop this from happening? It's frustrating to have to highlight every new row in white! Thanks!

Find more posts tagged with

Sheets

Real Estate

Support

Comments

Jamison

I can't replicate that - any chance you accidentally copied some formattting from the section names (menu, invitations)?

Did you look at the conditional formatting rules? It appears the only ones in that sheet when you create it are for a gray strikethrough and a red color to the font.

Travis

I would check conditional formatting rules (as suggested by Jamison) and highlight changes. Highlight changes can be enabled through the toolbar and will highlight cells that be been changed (such as new rows).

eshawes

Thanks for your replies! The first thing I checked were the conditional formatting rules. I deleted the two that were in there orignally and then added two new ones. Both conditions are simply if a certain column isn't blank then highlight that entire row. Not only are those highlight colors different than the random ones that just pop up, but those random ones are only certain columns, not the entire row. Strangely, another problem I seem to have with this template is that, on all new rows I've added, when I add new information, Strikethrough, gets applied. This seems similar to the conditional formatting that was in there when I started with the template, but, like I said, I deleted that rule. Jamison's first point is the only other thing I can think of, that I accidentally copied formatting from a different row when I added the new rows. I don't really know how to check on that but I do know that I inserted the new rows in between rows that had no highlighting so I don't understand why they would be picking up a format to highlight certain cells. Thanks for your help but since it seems like there isn't an obvious answer to this one, I'll probably just start over with a blank sheet and recreate the template in hopes that neither of these issues will be there in a brand new sheet. Thanks again!

Travis

I would love to take a look at the sheet to investigate! Would you be willing to share the sheet to support+travis@smartsheet.com as an Admin?

Thanks!