I have been trying to find a code which highlight Gantt Chart, Remaining and Completed days through code. I have added three buttons and i want that when i press the Completed button then chart should highlight only for complete.
If i press the Remaining it should highlight the remaining color
If i press the both Button it should highlight both.
Currently my Sheet is working through Conditional Formatting if you change the percentage it will work accordingly same thing i want from above buttons. I have tried to find this thing online but nothing is available. Any help will be greatly appreciated.