1. Select the cell/Range (say A1:A10). Please note that the cell reference A1
mentioned in the formula is the active cell in the selection. Active cell
will have a white background even after selection

2. From menu FormatConditional Formatting

3. For Condition1Select 'Formula Is' and enter the below formula (copy
paste the below)

=LEFT(A1,2)="PC"

4. Click Format ButtonPattern and select your color (say Red)

5. Hit OK



If this post helps click Yes
---------------
Jacob Skaria


"jc132568" wrote:

Dear Experts,
I would like to enter a conditional formatting criteria whereby the cell
should bold the contents if the cell contains a string which starts with the
letters PC.
e.g. PC1003
Is this possible?
regards
Martina