Conditional Formatting Gantt Bars & Other Columns

MaloyJF

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.

Example:

• 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

Paul Newcome

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

Paul Newcome

You can do this with two separate rules since you have two separate rules you want to format.

MaloyJF

@Paul Newcome. Thanks for the reply. I tried 2 separate rules, but to apply formatting to the gantt bar, the "entire row" needs to be selected. That seems to be over-riding my second rule when applying formatting to a column.

Am I missing something?

Paul Newcome

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

MaloyJF

@Paul Newcome. Rearranging the rules worked! I put the date rules above the gantt bar rules and they are all working now. Thanks for your help!

MaloyJF

Paul Newcome

Happy to help. 👍️