Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting scrambled when combined with sorting in 200
How can various CF's in the same column stay referenced to their relative
cells when a sort is applied? eg I apply a specific CF to values in column B that correspond to the cells in column A that read "Large". I have a different CF in column B for cells in column A that read "Small". Then when I sort any other column, the formatting gets scrambled. -- thanks in advance! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting scrambled when combined with sorting in 200
Hi COB:
Can't you set the CFs in the general case for all the cells in the column where there is data. This will check if cell is large or if it is small. -- Hope this helps Martin Fishlock, www.nyfconsultants.com, Wolverhampton, UK Please do not forget to rate this reply. "COB" wrote: How can various CF's in the same column stay referenced to their relative cells when a sort is applied? eg I apply a specific CF to values in column B that correspond to the cells in column A that read "Large". I have a different CF in column B for cells in column A that read "Small". Then when I sort any other column, the formatting gets scrambled. -- thanks in advance! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting scrambled when combined with sorting in
Not that I know of. Putting it another way, I want to have 2 different CF's
in the same column which each reference either 'large' or 'small' in another column. I'm not an advanced user so I'll try to picture out what I mean... A B C D E 1 TYPE Age S-L L-L 2 Small 6.4 3 Large 8.0 4 Large 10.2 I want to have CF's set in column B to consider either types 'Small' or 'Large' in column A. eg. If B2 is a 'Small' then reference D1 (Small's limit). If B2 is a "Large" then reference E1 (Large's limit). Note: Larges have a lifespan of 10 yrs whereas Smalls have a lifespan of only 6 yrs; that's why I cannot apply the same CF to both equally. -- thanks in advance! "Martin Fishlock" wrote: Hi COB: Can't you set the CFs in the general case for all the cells in the column where there is data. This will check if cell is large or if it is small. -- Hope this helps Martin Fishlock, www.nyfconsultants.com, Wolverhampton, UK Please do not forget to rate this reply. "COB" wrote: How can various CF's in the same column stay referenced to their relative cells when a sort is applied? eg I apply a specific CF to values in column B that correspond to the cells in column A that read "Large". I have a different CF in column B for cells in column A that read "Small". Then when I sort any other column, the formatting gets scrambled. -- thanks in advance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting spreadsheet with conditional formatting | Excel Discussion (Misc queries) | |||
Formulas scrambled when sorting | Excel Worksheet Functions | |||
Sorting Cells with Conditional Formatting | Excel Discussion (Misc queries) | |||
Conditional formatting combined with multiple IF statements | Excel Worksheet Functions | |||
Keeping conditional formatting when sorting | Excel Discussion (Misc queries) |