<div>
Can you supply a sample workbook so I can know exactly what purple and green look like since there are many shades of each?
</div>


Can you supply a sample workbook so I can know exactly what purple and green look like since there are many shades of each?


test.xlsx [https://filedb.experts-exchange.com/incoming/2019/03_w11/1415189/test.xlsx]

test.xlsx

<div>
There does not seem to be any data (regardless of color) that workbook.
</div>


There does not seem to be any data (regardless of color) that workbook.

<div>
i stripped it out for security reasons. i just want to replace the colour please
</div>


i stripped it out for security reasons. i just want to replace the colour please

<div>
Okay I can understand the need for security but could you add a few cells worth of dummy data with some purple and green colors?
</div>


Okay I can understand the need for security but could you add a few cells worth of dummy data with some purple and green colors?

<div>
i have though <br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2019/03_w11/1415191/Capture.PNG" target="_blank" title="example (15 KB)"><img alt="example" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2019/03_w11/800_1415191/Capture.PNG" /></a>
</div>


i have though

examplehttps://filedb.experts-exchange.com/incoming/2019/03_w11/1415191/Capture.PNG

Capture.PNG

<div>
Are you saying that you want to color the cells that say &quot;Domains&quot;, &quot;Notes&quot;, etc green? Regardless of the answer to that question I still need to see the green color.
</div>


Are you saying that you want to color the cells that say "Domains", "Notes", etc green? Regardless of the answer to that question I still need to see the green color.

<div>
<div class="content wysiwyg-content">
I have an excel workbook with lots of sheets in it with the colour puple in some of the cells. I want to create a macro that I can run to search the whole workbook and where the colour purple is found replace it with the colour green. Mnay thanks
</div>
</div>


I have an excel workbook with lots of sheets in it with the colour puple in some of the cells. I want to create a macro that I can run to search the whole workbook and where the colour purple is found replace it with the colour green. Mnay thanks

Macro to search a whole excel workbook for the colour purple and replace it

Windows Macro

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.