Lock Conditional Formatting in Excel 2007
 

Ok... I'm needy as hell, I know. I love the gradiant conditional formatting
and already I want more!!! So... Here's my dilema. I have a spreadsheet
that looks like this:

[A1]SalesRep A [B1]Sales [C1] $100
[A2]SalesRep A [B2]GM [C2] $ 20
[A3]SalesRep A [B3]Movement[C3]200
[A4]SalesRep B [B4]Sales [C4] $100
[A5]SalesRep B [B5]GM [C5] $ 20
[A6]SalesRep B [B6]Movement[C6]200
etc...

Since I want to compare "Apples to Apples" I will sort by Column B and then
apply conditional formatting to sales, Gm, and movement (separately... with
different beautiful colors). That part I have. What i need to do is lock
the appearance of those cells (both the gradiant color and the bar length) so
that they do not change when I re-sort by column A. Got it? Does anyone
have any idea how to do this? I know that I could skip the whole
sort/re-sort thing and conditially format an array of cells, but that is a
lot more complicated.