Format Excel cells which contain specific text

This is a fairly easy one to do, because you can format cells to contain a specific set of characters or words using Excel’s in-built conditional formatting.

 

Instructions

1) Highlight the relevant range of cells to format.

2) Go to the Home tab, then within the Styles section of the ribbon drop-down Conditional Formatting and select New Rule.

3) Choose ‘Format Only Cells that contain’ and under ‘Format only cells with’ select ‘Specific Text’.

4) Select whichever option is suitable for you from: containing, not containing, beginning with, ending with. In this case ‘containing’ is used to highlight any British Monarchs with ‘VI’ anywhere in their name. So this will also pick up the VII and VIII monarchs, and because it isn’t case-sensitive it will also pick up any others with vi anywhere in the name, such as Victoria.

 

FormatSpecificText1

 

Then just set your desired format, in this example highlighted yellow with bold font.

 

FormatSpecificText2

 

2 Comments on “Format Excel cells which contain specific text

  1. I¡¯ve learn some just right stuff here. Definitely price bookmarking for revisiting. I wonder how much effort you put to create one of these wonderful informative web site.

Leave a Reply

Your e-mail address will not be published. Required fields are marked *