View Single Post
 
Old 01-20-2023, 04:33 AM
Marcia's Avatar
Marcia Marcia is offline Windows 11 Office 2021
Expert
 
Join Date: May 2018
Location: Philippines
Posts: 526
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default Select fill colors in a workbook, change to another color

Hi. I would like to ask help for a code that selects all fill colors RGB (220, 230, 241) in a workbook saved as "ALL FUNDS DECEMBER 2022.xlsm" then change them to RGB (253, 233, 217).
Every year, I change the fill colors that I use in our agency's annual finance reports and supporting schedules and there were more than 100 cells/range to change.
Thank you.
Reply With Quote