Conditional Formatting - letters present
 

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

Conditional Formatting - letters present
 

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

Conditional Formatting - letters present
 

Magic! Many thanks.
regards
Martina

"Jacob Skaria" wrote:

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

Conditional Formatting - letters present
 

On Sun, 1 Nov 2009 17:41:01 -0800, Jacob Skaria
wrote:

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



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?

Conditional Formatting - letters present
 

--If you are using XL2007 goto Home tabStylesConditional FormattingManage
rulesNew ruleUse 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
---------------
Jacob Skaria


"CellShocked" wrote:

On Sun, 1 Nov 2009 17:41:01 -0800, Jacob Skaria
wrote:

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



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?
.

Conditional Formatting - letters present
 

On Mon, 2 Nov 2009 06:43:01 -0800, Jacob Skaria
wrote:

--If you are using XL2007 goto Home tabStylesConditional FormattingManage
rulesNew ruleUse 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.