Background color does not move with content when sorting rows in a Writer Table

[jzelliott]

I have a TTD list (Things To Do) in the form of a Writer table.
On the left is a column labelled “Priority”:

1. Things that must be done today
2. Things that can wait until tomorrow
3. Non-urgent things, not to be forgotten, but only to be done when convenient.

In the middle is a column labelled “Description”.

Each day I scan the Description column and adjust the number in the Priority column cells according to the importance of the task/thing/job described. Then I sort the table according to column 1 (Priority), so that all the ‘ones’ (1) come out on top; twos next; and threes at the bottom of the list.

For reasons I need not go into here, 5 rows have a yellow background, and should always be on top. If, however, I decide to downgrade one of those rows temporarily, say to Priority=2, then the contents of the row cells, including the Description, will sort as planned, but the yellow background will be left behind, and another Priority 1 content copied over it.

Q: How do I get the cell background to move with the cell content in a sort?

Many thanks,
Jim

[erAck]

Note: I moved this to the English category, as Site Feedback is for feedback about this Ask site.

[EarnestAl]

If you want to use Writer rather than Calc you could colour the background of the paragraph rather than the cell

[jzelliott]

Thanks for that

James Elliott BSc(WA) MAACB GradDipCompSt(Murdoch) JP

[Lupp]

@jzelliott

How do I get the cell background to move with the cell content in a sort?

I don’t think there is a way to do this with a TextTable.
Use a spreadsheet (Calc). There you have the option to move attributes (formats) with the data when sorting a range.

Many more advantages.