View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
 
Posts: 3,986
Default 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?