I am trying to build a truck dispatching spreadsheet. If I have a dropdown
list of timed truck runs, is it possible, after selecting one, to have it
color a range across columns that represent the amount of time blocked for
that particular load?
For example, if one option was "Load from Atlanta to Charleston (6hrs)", is
there a way to have it color a range of six cells? (Each column represents an
hour. There are 12 across from 0600 to 1800.)
How do you associate a time to a dropdown option and a color to an option?
Or, what is the best way to do this?
Thanks in advance.