Forum Discussion

Jakub Lagan's avatar
Jakub Lagan
Copper Contributor
May 03, 2018

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!

Resources