Make text color match cell color with macro?
 

Let's say I have a series of cells filled with different colors. Each cell
also contains a number used for sorting. (I've heard you can sort by color
alone, but we haven't gotten that far yet). Can anyone suggest a macro that
will "look at" the cell fill color, and format the text to the same color so
it's invisible?

Make text color match cell color with macro?
 

You can make your life more difficult by putting that stuff all in one cell, but
why not just use an extra column. You can use that extra column as one of the
sort keys. Then if you don't want to see it, you can hide that column.


JoeSpareBedroom wrote:

Let's say I have a series of cells filled with different colors. Each cell
also contains a number used for sorting. (I've heard you can sort by color
alone, but we haven't gotten that far yet). Can anyone suggest a macro that
will "look at" the cell fill color, and format the text to the same color so
it's invisible?

--

Dave Peterson