Conditional Formatting

[the_deejus]

Hi,
Just wondering, is it possible to 'lock' the conditional formatting in place so that when one has a column and someone else uses "sort ascending" A->Z button, the formatting behind the text doesnt follow it all over the place.
I have conditional formatting in some rows/columns which when a date is placed in column'L' the whole row turns from red to black. (dont remember the formula) but when people sort the column, I've found the formatting behind the text also moves up or down the column. This means that adding a date in (lets say) L8 changes the row to black in row 6 instead of row 8.

Can the formulas be locked in Excel so every thing says where it is suppose to?

 

[Oaktree]

Not sure I understand.

If I set A1's conditional formatting to formula is =$L$1<>"" and apply a red background and sort column L (so that what used to be L1 is now L3), the conditional formatting in A1 still references (the new) L1 (instead of the old L1/new L3) which I think it what you'd like to happen. Maybe I'm misinterpreting your question?