Sort a column based on Font Color

[tdyl1969]

Hi:

I have a spreadsheet which was generated by crystal reports. The numbers font color vary between three colors, which helps me recognize what type of transaction they are. is there a way via macro to sort this values based on font color?


Thanks,

Tim

[Macdave_19]

Think you'd need to proved people with the colours (in RGB format or the colorIndex)

this may help: