Forum Discussion
amandaSST
Dec 22, 2021Copper Contributor
Conditional Formatting to highlight whole row
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!
Let's say that the product name is in column B and that the data are in rows 2 to 1000.
- Select rows 2 to 1000. The active cell in the selection should be in row 2.
- On the Home tab of the ribbon, click Conditional Formatting > New Rule...
- Select 'Use a formula to determine which cells to format'.
- Enter the formula
=ISNUMBER(FIND("EOL",$B2))
- Click Format...
- Activate the Fill tab.
- Select a highlight color.
- Click OK twice.
4 Replies
Sort By
Let's say that the product name is in column B and that the data are in rows 2 to 1000.
- Select rows 2 to 1000. The active cell in the selection should be in row 2.
- On the Home tab of the ribbon, click Conditional Formatting > New Rule...
- Select 'Use a formula to determine which cells to format'.
- Enter the formula
=ISNUMBER(FIND("EOL",$B2))
- Click Format...
- Activate the Fill tab.
- Select a highlight color.
- Click OK twice.
- DraygonTechCopper ContributorThis worked wonderfully, thank you!
But is there a method to reach this goal, that still allows me to manually fill a cell in that row with a different color?
It seems that the formula overwrites immediately, and the entire row stays highlighted.
Thanks in advance,
- TonyConditional Formatting always overrides manual formatting - that's the whole idea...
- amandaSSTCopper ContributorThat's it thank you!!