Conditional Formatting Gantt Bars & Other Columns

MaloyJF ✭✭
edited 04/05/24 in Smartsheet Basics

Currently, if conditional formatting is applied to Gantt bars, the format must be applied to the "entire row".

I would like the ability to apply conditional formatting to the Gantt bars and additional formatting to individual columns.


  • format Gantt bars red, yellow, and green for large, medium, and small impact
  • format start and end dates grey if they are in the past

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    If you do not adjust any other formatting in the rule used to format the Gantt bar, it should not apply formatting to anything other than the Gantt bar. If it still is, try rearranging your rules so that the rule affecting the columns is above the rule that affects the Gantt bar (also assumes you didn't adjust Gantt bar formatting in the rule that affects the columns).