how do I automatically group according to text color?
 

i have different rows with color denoting the status of the row, I would like
to set it up that excel automatically organizes them in groups according to
the text color. Is this possible?

how do I automatically group according to text color?
 

Yes, it is possible to group them using the Range().Font.ColorIndex
properties as the selection criteria.

"Kassin" wrote:

i have different rows with color denoting the status of the row, I would like
to set it up that excel automatically organizes them in groups according to
the text color. Is this possible?

how do I automatically group according to text color?
 

Can you please be a little more detailed?