Hi Folks,
This question probably has a simple answer, but my knowledge of VB is extremely limited. If this can be solved formulaically in excel without writing a VB script, that would be preferable. Here is the problem:

I have an excel sheet with several thousand line items, some of which need to be removed. The font color on these has been changed to red to indicate this; however, there is no (column)indicator to separate these from the other line items, and the red ones are interspersed throughout the records.

If the font color for a particular cell can be revealed (i.e. showing the xlcolorindex font value for the cell (black=1, red=3, etc.)) then one can quickly sort on the index value to group these by color.

Is this possible to solve by using a formula, or is vbasic the only recourse? What is the simplest way to do this?

Thanks for your help.

Regards,

GL