Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting in Excel 2007 | Excel Discussion (Misc queries) | |||
How to lock conditional formatting in pivot tables? | Excel Discussion (Misc queries) | |||
Conditional Formatting in Excel 2007 | Excel Discussion (Misc queries) | |||
Conditional Formatting to Lock Cells | Excel Worksheet Functions | |||
Conditional formatting in Excel 2007 | Excel Discussion (Misc queries) |