Conditional Formatting

[Tim Mills]

I have a sheet with categories Investment Trust and AIM
in col J. I can get the text to change colour along the
whole row according to the category with the following
formula in CF in col J

=$J1="Investment Trust"
=$J1="AIM"

but lose the format after sorting. Is there a way of
maintaining the CF after sorting?

I'm on Win 2000 & XL 2000

Thanks
Tim

 

[Paul]

I have a sheet with categories Investment Trust and AIM
in col J. I can get the text to change colour along the
whole row according to the category with the following
formula in CF in col J

=$J1="Investment Trust"
=$J1="AIM"

but lose the format after sorting. Is there a way of
maintaining the CF after sorting?

I'm on Win 2000 & XL 2000

Thanks
Tim

It works for me. Are you sure you are doing the sort correctly? That is,
have you selected the whole data area before sorting, so that all data (and
not just one or two columns) gets sorted?