Highlight cells containing string [Conditional formatting]
Excel allows you to quickly highlight cells containing a given text string.
How to apply Conditional Formatting
- Select cell range.
- Go to tab "Home" on the ribbon if you are not already there.
- Press with left mouse button on "Conditional formatting" button.
- Press with mouse on "Highlight Cells Rules".
- Press with left mouse button on "Text that Contains..."
- A dialog box appears that lets you specify the text string and the formatting. Press with left mouse button on the arrow to select a cell value that contains the text string to be used, in this case, cell C14.
- Pick a formatting or use a custom format.
- Press with left mouse button on OK button.
Highlight cells rules category
Excel has a built-in feature that allows you to highlight dates if a given condition is met. Section 1 below […]
Excel lets you easily highlight values based on a condition you specify, with a built-in formatting or a custom formatting. […]
Excel has a few built-in conditional formatting features, one of them highlights values that have at least one duplicate. The […]
Conditional Formatting categories
Excel categories
Leave a Reply
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.