Dec 22 2021 07:50 AM
We have a big product database and I'd like to be able to get excel to highlight the whole row if a product contains the text "EOL".
It seemed quite straightforward but I can't get it to work.
The column with the product name could be Stone EOL or Porcelain EOL for example so it wouldn't just be the phrase "EOL" it is searching for
Any help much appreciated!
Dec 22 2021 08:05 AM
SolutionLet's say that the product name is in column B and that the data are in rows 2 to 1000.
=ISNUMBER(FIND("EOL",$B2))
May 05 2022 03:38 PM
May 06 2022 01:00 AM
Conditional Formatting always overrides manual formatting - that's the whole idea...
Dec 22 2021 08:05 AM
SolutionLet's say that the product name is in column B and that the data are in rows 2 to 1000.
=ISNUMBER(FIND("EOL",$B2))