how do I automatically group according to text color?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Yes, it is possible to group them using the Range().Font.ColorIndex
properties as the selection criteria.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Wierd Formula Request 2
How to type each letter of the alphabet automatically in a specific color in Word? 0
Excel VBA - counting cells by colors and names to it in two different rows. 0
RDBMerge Text limit 0
A macro to color the cells according to the values existing in a c 2
VBA Conditional formating for specific text in several columns 1
Color rows by "group" 6
conditional format - table - cell empty return default color 1

Back
Top