Hello. How do you look for a non-standard color and replace it? I know how to do find and replace but if I don't know what color it is, it's hard to select haha.
Hello. How do you look for a non-standard color and replace it? I know how to do find and replace but if I don't know what color it is, it's hard to select haha.
does standard mean no fill?
if not, please be more specific about what is and is not standard, what your range is and / or upload a sample showing what you're asking for.Please Login or Register to view this content.
Hope I could help - if your post has been solved don't forget to mark it as such.
Clicking the * below is a great way to say thanks!
"Drowning in 10 feet of water isn?t any different than drowning in a million feet. And if you can swim, it doesn?t matter how deep the ocean is. At some level, once you realize you?re in water that?s too deep to stand, you have to have a very different approach," - Joi Ito
is this the same request as your previous post...?
http://www.excelforum.com/excel-prog...ml#post4021439
It's related but not the same thing. The other request is asking for vba code to replace cell color based on color of cell above. This is just asking how to efficiently do a search and replace for colors when the color isn't one of the standard colors in the palette. For example if someone colored a row an off blue, it's not selected in the regular colors. How do I know which color to search for?
how bout this:
Formula:Please Login or Register to view this content.
where you'll need to pick w/e themecolor you want to replace it with.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks