Conditional Formatting - letters present

jc132568 · External Since: Sep 02, 2009 Posts: 3

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 · External Since: Mar 04, 2009 Posts: 441

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

jc132568 · External Since: Sep 02, 2009 Posts: 3

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

CellShocked · External Since: Oct 22, 2009 Posts: 5

On Sun, 1 Nov 2009 17:41:01 -0800, Jacob Skaria
<JacobSkaria.TakeThisOut@discussions.microsoft.com> 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 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 · External Since: Mar 04, 2009 Posts: 441

--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
---------------
Jacob Skaria

"CellShocked" wrote:

> On Sun, 1 Nov 2009 17:41:01 -0800, Jacob Skaria
> <JacobSkaria.TakeThisOut@discussions.microsoft.com> 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 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?
> .
>

CellShocked · External Since: Oct 22, 2009 Posts: 5

On Mon, 2 Nov 2009 06:43:01 -0800, Jacob Skaria
<JacobSkaria RemoveThis @discussions.microsoft.com> wrote:

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