String Comparison & Conditional Formatting

[Blobbies]

I am wanting to colour a Sports Tipping results table according to the sports
result.

I have a green font for getting it exactly right, a red strikethrough font
for getting it exactly wrong, and would like a grey font for getting it
partially correct.

So, I need a formula to place in the conditional formatting dialog that
compares cell A with cell B. If the 1st 5 letters of cell A equal the first
5 letters of cell B, then turn the font grey!

Many thanks in advance for your assistance.



Eddie

[Biff]

Hi!

Try this:

=LEFT(A1,5)=LEFT(B1,5)

Biff

"Blobbies" <[email protected]> wrote in message
news:[email protected]...
>I am wanting to colour a Sports Tipping results table according to the
>sports
> result.
>
> I have a green font for getting it exactly right, a red strikethrough font
> for getting it exactly wrong, and would like a grey font for getting it
> partially correct.
>
> So, I need a formula to place in the conditional formatting dialog that
> compares cell A with cell B. If the 1st 5 letters of cell A equal the
> first
> 5 letters of cell B, then turn the font grey!
>
> Many thanks in advance for your assistance.
>
>
>
> Eddie
>
>

[Blobbies]

It's so easy when you know!

Thanks Biff - Fantastic!!!



"Biff" wrote:

> Hi!
>
> Try this:
>
> =LEFT(A1,5)=LEFT(B1,5)
>
> Biff
>
> "Blobbies" <[email protected]> wrote in message
> news:[email protected]...
> >I am wanting to colour a Sports Tipping results table according to the
> >sports
> > result.
> >
> > I have a green font for getting it exactly right, a red strikethrough font
> > for getting it exactly wrong, and would like a grey font for getting it
> > partially correct.
> >
> > So, I need a formula to place in the conditional formatting dialog that
> > compares cell A with cell B. If the 1st 5 letters of cell A equal the
> > first
> > 5 letters of cell B, then turn the font grey!
> >
> > Many thanks in advance for your assistance.
> >
> >
> >
> > Eddie
> >
> >
>
>
>

[Biff]

You're welcome!

Biff

"Blobbies" <[email protected]> wrote in message
news:[email protected]...
> It's so easy when you know!
>
> Thanks Biff - Fantastic!!!
>
>
>
> "Biff" wrote:
>
>> Hi!
>>
>> Try this:
>>
>> =LEFT(A1,5)=LEFT(B1,5)
>>
>> Biff
>>
>> "Blobbies" <[email protected]> wrote in message
>> news:[email protected]...
>> >I am wanting to colour a Sports Tipping results table according to the
>> >sports
>> > result.
>> >
>> > I have a green font for getting it exactly right, a red strikethrough
>> > font
>> > for getting it exactly wrong, and would like a grey font for getting it
>> > partially correct.
>> >
>> > So, I need a formula to place in the conditional formatting dialog that
>> > compares cell A with cell B. If the 1st 5 letters of cell A equal the
>> > first
>> > 5 letters of cell B, then turn the font grey!
>> >
>> > Many thanks in advance for your assistance.
>> >
>> >
>> >
>> > Eddie
>> >
>> >
>>
>>
>>