To continue my quest for that perfect Gantt chart I need some
insight into the workings within Excel color palette.
I have spreadsheet (A) that has the colors I want to use for the Gantt
chart. Therefore, I get the RGB numbers from A and plug into the VBA code in
the Gantt bar spreadsheet. When I compare colors side by side with both
spreadsheets open, the colors do not match.
For example, color set (255, 204,153) in VBA, results in color (255,255,153)
in the Gantt. I have looked for logic errors, and do not see anything
obvious (but I could be wrong). If anyone can point me to related material
or different line of inquiry to pursue, I would greatly appreciate.