![Find Replace On Excel For Mac Find Replace On Excel For Mac](/uploads/1/2/5/4/125423624/408084825.gif)
In the Find and Replace dialog box, click Find Next or Find All. Find text with specific formatting and replace the formatting You can find and replace text with special formatting, such as bold or highlight, by using the Format menu. The Microsoft Excel REPLACE function replaces a sequence of characters in a string with another set of characters. The REPLACE function is a built-in function in Excel that is categorized as a String/Text Function.It can be used as a worksheet function (WS) in Excel.
![Find Find](/uploads/1/2/5/4/125423624/306929188.png)
Hi I am using excel 2016 on mac and on windows 10 laptops. I have a large database of reports which I have to work with. Each report is occupying one excel cell (50 - 200 words). On windows computer I am able to look for a specific word within the cell and change the colour of the cell if this word is present (I use find - replace function, with replaced word being the same but I change the cell formatting to a different colour). However, on mac the find-replace function does not seem to have the cell formatting part to it. Help?:) Thank you!