LinkBack URL
About LinkBacks
Is there a global way to change all of one color to another, without clicking on each cell ?
Example - I want to change all of the dark green fill to light green.
Is there a global way to change all of one color to another, without clicking on each cell ?
Example - I want to change all of the dark green fill to light green.
Last edited by x65140; 06-04-2012 at 03:58 PM. Reason: solved
Good day,
Am not sure of the Excel version you are using, however newer versions have filtering capabilities based on colour. Once filtered you can select each individual column and do the replacement. You'd still have to do this individually for each column though!
hi,
you should know which interior.colorindex has your cell and what value is of your needed colour
try this
Please Login or Register to view this content.
Best Regards
MaczaQ
---------------------------------------------------------------------------------------------------------------------------
If you are satisfied with the solution(s) provided, please mark your thread as Solved
If you are pleased with my answer consider to rate it. To thank someone who has helped you, click on the star icon below their name.
- This way you will add him some reputation points ... thanks in advance.
Appreciate both responses! This is 2010 (sorry forgot to mention) - and it did already have some kind of filters set up - so I was able to explore that route and change what I needed.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks