Conditional formatting scrambled when combined with sorting in 200

[COB]

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.

 

[Martin Fishlock]

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.

 

[COB]

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.

 

[COB]

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.