Forum Discussion
fill color
Hello! Is there a way to change all cells that have a particular fill color to a different fill color without having to manually change them all? The fill color I selected will not translate to a different application so I wanted to change it all and wanted to figure out if there's an easier way than doing them all individually.
Thanks!!!
5 Replies
Oh, I found out what I was doing wrong. First you have to "find all", then "replace all". It replaced 583 cells, so thanks, it would have taken me forever!
I must be doing something wrong. This only works if there is nothing in the cell. What I want to do is to replace the cell colour only, leaving the content of the cell unchanged. Is there a way to do that or am I just not understanding the instructions?
- thank you!!!!
chimmykimmy , you are welcome
