We have a spreadsheet that we use to track the jobs our company needs to bid. When the drawings have been downloaded to our server, I format a dedicated cell next to each job with a purplish color and a thick black border on all 4 sides. When the job has been plotted out, an "X" is typed into that box.
As the work day proceeds, new jobs are added to the schedule with a time and job name. Each day I go in to sort the jobs on the schedule. I always start sorting by the time, and then by the job name in alphabetical order. That sorts perfectly each time. The problem I run into is not all of the jobs have been downloaded, thus are not formatted as described above. So when the sort happens, the fill moves, but the border does not.
I need the formatting to move with the rest of the information on that row.
How can I make that happen and will we be able to add an "X" to the cell without messing up that formatting?
Thanks,
Chris
As the work day proceeds, new jobs are added to the schedule with a time and job name. Each day I go in to sort the jobs on the schedule. I always start sorting by the time, and then by the job name in alphabetical order. That sorts perfectly each time. The problem I run into is not all of the jobs have been downloaded, thus are not formatted as described above. So when the sort happens, the fill moves, but the border does not.
I need the formatting to move with the rest of the information on that row.
How can I make that happen and will we be able to add an "X" to the cell without messing up that formatting?
Thanks,
Chris