Nope. You could only mimic these by having the formatted cells that referred
to the sorted cells via the INDIRECT function.

--
Best Regards,

Luke M
"Court" wrote in message
...
I want to Lock the formatting on an excel sheet so when i sort the data in
the sheet the background colors and cell formatting stay in place, and
just
the data shifts. Is this possible?