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