Sorting Formatted Cells

ceranes

New Member
Joined
Jan 19, 2018
Messages
12
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
 

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

Watch MrExcel Video

Forum statistics

Threads
1,118,776
Messages
5,574,170
Members
412,574
Latest member
shadowfighter666
Top