Why are these columns blue in GanttView and how to do I remove it?

faith.kinyon

Hi everyone! I am running into an issue in my sheet, report, and dashboard. In the main sheet, I have several line items that associate with a gantt chart for project management. Three of them are highlighted / shaded in blue with no conditional formatting that correlates to that setting. Anyone know why this is occurring? Thank you in advance!

Samuel Mueller

@faith.kinyon If you have no conditional formatting rules turned on, then it has to be just regular formatting. You have to highlight the entire row while in gantt view by clicking the blue Row button on the far left of the row (in red circle), and then change the formatting.

Then you can choose the color, or clear it

Have you tried doing this? By clicking the blue row button on the far left?

Samuel Mueller

Hey @faith.kinyon, just want to confirm that they weren't just manually formatted that way. Like if you try to change the entire row to red, does it change it?

faith.kinyon

@Samuel Mueller Unfortunately not, and it only shows it in the gantt view and not the line items in the grid view, so it won't let me change any colors in the timelines on the gantt chart either.

Samuel Mueller

@faith.kinyon If you have no conditional formatting rules turned on, then it has to be just regular formatting. You have to highlight the entire row while in gantt view by clicking the blue Row button on the far left of the row (in red circle), and then change the formatting.

Then you can choose the color, or clear it

Have you tried doing this? By clicking the blue row button on the far left?

Samuel Mueller

@faith.kinyon hey I saw you accepted this, just want to make sure it solved your issue!

faith.kinyon

@Samuel Mueller Definitely a blonde moment ... thank you so much for your help!!!

Samuel Mueller

No worries! just wanted to make sure. Let me know if you need anything else.