Conditional Formatting

  • Thread starter Thread starter Tim Mills
  • Start date Start date
T

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
 
Tim Mills said:
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
Click to expand...


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?
 
Back
Top