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

Copper 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

@Duurs 

Did you try to pick format from the cell?

image.png

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

 

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