I have two columns of data (A:B), and want to highlight values in Col B in
coloured text, where the adjacent cell in Col A contains data entered in
brackets. The data in column A is a mixture of numbers and text and formatted
as 'General' so that a number in brackets does not appear as a negative
value. I've used CF before but can't seem to enter a formula that works.

Any ideas?

If there cannot be any other parenthesizes then you can use

In the CF use formula is and


=ISNUMBER(FIND("(",A1))


--


Regards,


Peo Sjoblom


"snakey" <(E-Mail Removed)> wrote in message
news:81537FA4-6134-4A0E-B5D2-(E-Mail Removed)...
>I have two columns of data (A:B), and want to highlight values in Col B in
> coloured text, where the adjacent cell in Col A contains data entered in
> brackets. The data in column A is a mixture of numbers and text and
> formatted
> as 'General' so that a number in brackets does not appear as a negative
> value. I've used CF before but can't seem to enter a formula that works.
>
> Any ideas?
>
>
>

1. Select the cell/Range (say b1:b10). Please note that the ROW reference 1
mentioned in the formula is the active ROW 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

=AND(LEFT(A1,1)="(",RIGHT(A1,1)=")")

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


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


"snakey" wrote:

> I have two columns of data (A:B), and want to highlight values in Col B in
> coloured text, where the adjacent cell in Col A contains data entered in
> brackets. The data in column A is a mixture of numbers and text and formatted
> as 'General' so that a number in brackets does not appear as a negative
> value. I've used CF before but can't seem to enter a formula that works.
>
> Any ideas?
>
>
>

Many thanks Jacob - works a treat!

"Jacob Skaria" wrote:

> 1. Select the cell/Range (say b1:b10). Please note that the ROW reference 1
> mentioned in the formula is the active ROW 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
>
> =AND(LEFT(A1,1)="(",RIGHT(A1,1)=")")
>
> 4. Click Format Button>Pattern and select your color (say Red)
> 5. Hit OK
>
>
> If this post helps click Yes
> ---------------
> Jacob Skaria
>
>
> "snakey" wrote:
>
> > I have two columns of data (A:B), and want to highlight values in Col B in
> > coloured text, where the adjacent cell in Col A contains data entered in
> > brackets. The data in column A is a mixture of numbers and text and formatted
> > as 'General' so that a number in brackets does not appear as a negative
> > value. I've used CF before but can't seem to enter a formula that works.
> >
> > Any ideas?
> >
> >
> >

Thanks Peo, this also works, as does Jacobs suggestion - will now decide
which one to use!

"Peo Sjoblom" wrote:

> If there cannot be any other parenthesizes then you can use
>
> In the CF use formula is and
>
>
> =ISNUMBER(FIND("(",A1))
>
>
> --
>
>
> Regards,
>
>
> Peo Sjoblom
>
>
> "snakey" <(E-Mail Removed)> wrote in message
> news:81537FA4-6134-4A0E-B5D2-(E-Mail Removed)...
> >I have two columns of data (A:B), and want to highlight values in Col B in
> > coloured text, where the adjacent cell in Col A contains data entered in
> > brackets. The data in column A is a mixture of numbers and text and
> > formatted
> > as 'General' so that a number in brackets does not appear as a negative
> > value. I've used CF before but can't seem to enter a formula that works.
> >
> > Any ideas?
> >
> >
> >
>
>
> .
>

If there can't be more than one left parenthesis in the cell which I assume
it is the case then I think mine is a tiny bit more robust since it is not
sensitive to an occasional misplaced leading space.

--


Regards,


Peo Sjoblom


"snakey" <(E-Mail Removed)> wrote in message
news:898687E8-C41F-4E1E-A1DE-(E-Mail Removed)...
> Thanks Peo, this also works, as does Jacobs suggestion - will now decide
> which one to use!
>
> "Peo Sjoblom" wrote:
>
>> If there cannot be any other parenthesizes then you can use
>>
>> In the CF use formula is and
>>
>>
>> =ISNUMBER(FIND("(",A1))
>>
>>
>> --
>>
>>
>> Regards,
>>
>>
>> Peo Sjoblom
>>
>>
>> "snakey" <(E-Mail Removed)> wrote in message
>> news:81537FA4-6134-4A0E-B5D2-(E-Mail Removed)...
>> >I have two columns of data (A:B), and want to highlight values in Col B
>> >in
>> > coloured text, where the adjacent cell in Col A contains data entered
>> > in
>> > brackets. The data in column A is a mixture of numbers and text and
>> > formatted
>> > as 'General' so that a number in brackets does not appear as a negative
>> > value. I've used CF before but can't seem to enter a formula that
>> > works.
>> >
>> > Any ideas?
>> >
>> >
>> >
>>
>>
>> .
>>