Make text color match cell color with macro?

J

JoeSpareBedroom

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?
 
D

Dave Peterson

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.
 

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

Excel Macro to automatically go to the right of the last colored cell 0
How do I preserve text color when combining cell data 3
make all cells in same row match cell formatted with fill color 2
macro for copying background color 1
Macro to set cell interior color? 4
Change cell fill color options 1
word match in string text in cell, color format cell 1
Cell Color Formating 6

Top