String Comparison & Conditional Formatting
 

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

String Comparison & Conditional Formatting
 

Hi!

Try this:

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

Biff

"Blobbies" wrote in message
...
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

String Comparison & Conditional Formatting
 

It's so easy when you know!

Thanks Biff - Fantastic!!!



"Biff" wrote:

Hi!

Try this:

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

Biff

"Blobbies" wrote in message
...
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

String Comparison & Conditional Formatting
 

You're welcome!

Biff

"Blobbies" wrote in message
...
It's so easy when you know!

Thanks Biff - Fantastic!!!



"Biff" wrote:

Hi!

Try this:

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

Biff

"Blobbies" wrote in message
...
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