Forum Discussion
Jakub Lagan
May 03, 2018Copper Contributor
Excel 2016 on Mac - find and replace with cell colour change
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!
- Jakub LaganCopper Contributor
any1 able to help?