Hi All,

If I have two columns A and B; column A contain text with "Bottle 123" and column B contain "B123". How can I use conditioning formatting on Column B, if column A contain the text "Bottle", highlight cell in column B green.


Kind regards,
Alex