May 02 2018
10:47 PM
- last edited on
Jul 25 2018
11:56 AM
by
TechCommunityAP
May 02 2018
10:47 PM
- last edited on
Jul 25 2018
11:56 AM
by
TechCommunityAP
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!
Jun 07 2018 08:02 AM
any1 able to help?