Conditionally formatting just part of a cell contents - how?

  • Thread starter Thread starter Mac
  • Start date Start date
M

Mac

Hello,

assume my cells ( e.g. A1:E10) are filled with words ( i.e. one word per one
cell); I want to find specific character groups, so if I am looking for a
group 'eel' and a cells contains 'peeling', I want that "eel" part to get
formatted. How could I go about this? In the next step, I would like to
obtain the character group to search for from a specific cell, like in -
"take the contents of F1 and search for it through A1:E10, if it is found,
format that part of a cell contents". Can anyone help?
 
Hi,

Can't do that with Conditional Formatting, you will need to write code. You
could use conditional formatting if you were willing to format the whole cell
if the specific characters matched.
 
Back
Top