How do I highlight columns on a gnatt chart

Audrey Kinvig

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

Richard Rymill SBP

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 

Audrey Kinvig

thanks Richard does this work for columns as well as rows?

Richard Rymill SBP

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

Audrey Kinvig

Got it! -  thank you for your expert help