I am finding it difficult doing find and replace using the formatting option. Trying to practice the lesson under Microsoft Excel for beginners. It keeps returning with an error “we couldn’t find anything to replace “
Please bear in mind that you need to recreate the exact same format to replace.
So, there’s also the ‘copy format’ functionality on the side of the find replace format box. Please take a look.