View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JoeSpareBedroom JoeSpareBedroom is offline
external usenet poster
 
Posts: 87
Default 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?