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.
How do I highlight columns on a gnatt chart
Hi
Please could someone help me with highlighting columns on a resourcing sheet I have just created.
I have the data on the rows and need to show when people are absent during the month by highlighting it.
Many thanks
Audrey
Comments
-
Audrey
Take a close look at Conditional Formatting on the tool bar and use the colour choices to turn your Gantt bars into a more clourful display. The only thing you cannot change is the colour of the Parent Gantt bar, which remains Grey.
We humans respond well to colour for absorbing complex data!
Good luck
RichardR
-
thanks Richard does this work for columns as well as rows?
-
Yes it does but make sure you run the rules in the right order so you get the outcome you seek.
Here are some help files...
http://help.smartsheet.com/customer/portal/articles/516441
Goodluck
RichardR
-
Got it! - thank you for your expert help
