From the Not Just Numbers blog:
Before I begin, I would like to wish a Happy New Year to all of my readers and subscribers – as this is my first post of 2016.
I am starting the year in humble mode, as I have had something very simple pointed out to me that I can’t believe I had never spotted, despite it being right under my nose!
In my last post of 2015, I showed you some code to swap one cell colour for another throughout a worksheet. I then received a comment from a reader that I only know as Jim, pointing out that Excel already has a very simple way of doing this!
It can in fact be done using Find and Replace.
This amazed me because I use Find and Replace all of the time and didn’t know you could do this!
It is simple as this:
- Highlight the range which you want to apply the changes to
- Click Find and Select (the binoculars icon) on the Home Ribbon and choose Replace from the dropdown menu
- Don’t enter anything in the Find or Replace boxes, but click the Format button next to the Find box and on the Fill Tab, select the colour that you wish to change
- Click the Format box next to the Replace box and on the Fill Tab, select the new colour that you wish to swap for the colour you selected above
- Click Replace All
If you enjoyed this post, go to the top of the blog, where you can subscribe for regular updates and get two freebies “The 5 Excel features that you NEED to know” and “30 Chants for Better Charts”.