Author Topic: Find/Replace specific words with colour and/or formatting in Excel  (Read 276 times)

spiros

  • Administrator
  • Hero Member
  • *****
  • Posts: 299355
  • Gender: Male
  • point d’amour
    • spiros.doikas
    • greektranslator
    • doikas
    • 102094522373850556729
    • lavagraph
    • Greek translator CV
Find/Replace specific words with colour and/or formatting in Excel

Normally, if you do that in Excel with Ctrl+H (Find/Replace dialog), the whole cell will be formatted.
A quick trick is to paste the text first in Word, do any formatting replacements, and then paste back to Excel.