Forum Discussion
Solved
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. ...
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.
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.
That's it thank you!!