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.
This 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,
- Tony
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,
- Tony
Conditional Formatting always overrides manual formatting - that's the whole idea...