ExcelBanter - Choose format while Find & Replace not working

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Choose format while Find & Replace not working (https://www.excelbanter.com/excel-discussion-misc-queries/256979-choose-format-while-find-replace-not-working.html)

ghitorni

Choose format while Find & Replace not working

My worksheet has various formats based on values. However when in Find &
replace, I use the color picker (Choose format from Cell), and click on
formatted cell, the Preview box never shows anything and hence the find
operation never gets along. What to do? Thanks

All times are GMT +1. The time now is 10:43 PM.