Conditional Formatting - letters present

[jc132568]

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

 

[Jacob Skaria]

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 Format>Conditional Formatting>

3. For Condition1>Select 'Formula Is' and enter the below formula (copy
paste the below)

=LEFT(A1,2)="PC"

4. Click Format Button>Pattern and select your color (say Red)

5. Hit OK



If this post helps click Yes

 

[jc132568]

Magic! Many thanks.
regards
Martina

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 Format>Conditional Formatting>

3. For Condition1>Select 'Formula Is' and enter the below formula (copy
paste the below)

=LEFT(A1,2)="PC"

4. Click Format Button>Pattern and select your color (say Red)

5. Hit OK



If this post helps click Yes

 

[CellShocked]

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 Format>Conditional Formatting>

3. For Condition1>Select 'Formula Is' and enter the below formula (copy
paste the below)

=LEFT(A1,2)="PC"

4. Click Format Button>Pattern and select your color (say Red)

5. Hit OK

Is that 2k7?

I do not get a "formula is" dialog anywhere.

I was able to do it though the menu dialogs though.

How does one lock it to only capital letters?

 

[Jacob Skaria]

--If you are using XL2007 goto Home tab>Styles>Conditional Formatting>Manage
rules>New rule>Use a formula to determine which cells to format..

--for exact match enter this formula in the box below:
=EXACT(LEFT(A1,2),"PC")

--Click the Format button. Select the desired style(s) and click OK

If this post helps click Yes

 

[CellShocked]

--If you are using XL2007 goto Home tab>Styles>Conditional Formatting>Manage
rules>New rule>Use a formula to determine which cells to format..
Exactly

--for exact match enter this formula in the box below:
=EXACT(LEFT(A1,2),"PC")

Cool! Thanks.

--Click the Format button. Select the desired style(s) and click OK

Or select the "Custom Style", and change nothing color or font wise,
and select "Bold" checkbox to arrive at the resuestor's query solution.