Search and replace Format not working in Office 365 (cant find items to replace)

New Contributor

I try to replace cell format colors in een sheet and I use the pick the cell format to replace but he isnt finding something. The sheet isnt protected.


If i do exactly the same within a new blanco sheet with a cell prepared same format color its finding it.


How or  why is this not working?

2 Replies


Did you try to pick format from the cell?


@Sergei Baklan offcourse. Maybe my txt wasnt good enough.


I wrote .... I use the pick the cell format