Top Ten Excel Annoyances
Subject:   Formatting does not move with a sort
Date:   2005-03-12 12:23:40
From:   ckoperniak
Excel does not provide users the option to attach formatting directly to the contents of a cell; rather, formatting is always maintained with the cell address. For example, if I perform a sort on a column of data, any bolding that exists with a particular cell will remain with the cell, rather than with the contents which have now moved.