Column Highlight

Welcome to the New Smartsheet Online Community


You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.

Column Highlight

is there the ability to colour in a column not a row to show for example UK bank holidays or staff holidays etc.. to show in a very quick visual way any clashes that might be avoided.

 

Comments

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi,

    Unfortunately, it's not possible at the moment, but it's a great idea!

    Please submit an Enhancement Request when you have a moment.

    Have a fantastic week!

    Best,

    Andrée Starå

    Workflow Consultant @ Get Done Consulting

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • Mike WildayMike Wilday ✭✭✭✭✭

    You could use conditional formatting to format just the field in the column you're searching for rather than applying it to the whole row. If the fields in that column match your criteria, it would essentially color the whole row. You can also manually color in the row by highlighting the entire column and changing the color of the background. 

    Let me know if you have any questions. 

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    I read your question wrong and that you meant the Column Titles.

    Mike is right, and I often use conditional formatting in my solutions to color whole columns and rows to make it easier to keep the design as intended.

    Best,

    Andrée

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    The conditional formatting doesn't even have to apply to the column that is being used for the criteria. You could set it to highlight only the cells in column B where the corresponding cells in column A contain a certain value.

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Exactly, I sometimes use it to format multiple months or values in that way.

    Works great!

    Best,

    Andrée

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

Sign In or Register to comment.