sort by font format?

[Roni]

is it possible to sort Excel file rows based on the formatting. I have a long list of information, and some rows are in STRIKE THROUGH font (b/c they need to be removed). Is there a way I can sort the whole list having all the STRIKE THROUGH rows end up at the end (or the beginning)? and on the same note, can I also sort by font color? (in addition to the strike throughs, i also have a number of rows in RED FONT that would be nice to have all together).

 

[Roni]

OHHHHHHHHH, I finally sorted it out... I can't do that in a SHARED file. once i took the SHARING off, it worked perfectly. god was that frustrating. thanks for all your help'

 

[erik.van.geit]

yes that's how i was deleting modules. but i can't tell if i got rid of all of them. Erik, if i use your code, do i still use the same formula in the online text (=ColorIndexOfCell(A1,TRUE,TRUE) and how can i tell if the code is checking font color? i want it to check font color.

I told you it is currently set to font color
there are some numbers which correspond to some settings
the list is within the macro

this macro is not a function (so cannot be used this way with a formula on the sheet)
it is a SUB which does some actions on your sheet
you can read about in the helpfiles ...
... and of course ...
on the Board !

enjoy :wink:
Erik