I don't understand it either because I need to figure this out for my
business. I think that I might contact microsoft office for a solution. I
still have one free time to contact them.

"Ken Johnson" wrote:

Hi CoCoa,
Oops!

I honestly thought that fill color would not be affected by sorting.
After trying it out I have to ever so humbly retract that statement.
Sorry about that.

Ken Johnson