Hi CoCoa,
If I'm correct in assuming that you want the cells' fill colors not to
be affected by the sorting then one way is to use conditional
formatting.

Say you want A1 to have a yellow fill, then go:

FormatConditional Formatting... select "Formula Is" in left box
type "=OR(NOT(ISBLANK($A$1)), ISBLANK($A$1))" in the right box
(without the speech marks) Click on the Format... buttonselect yellow
fill then click OK.

This over-rides the normal fill color that moves when sorting.

The Formula used is true regardless of what type of data is in A1.

Tedious aye.
Ken Johnson