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.

Cell Highlights Automatically

edited 12/09/19 in Archived 2015 Posts

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!


  • Jamison
    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
    Travis Employee
    edited 08/31/15

    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). 

  • 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
    Travis Employee
    edited 09/01/15

    I would love to take a look at the sheet to investigate! Would you be willing to share the sheet to [email protected] as an Admin?



This discussion has been closed.