String Comparison & Conditional Formatting

[Guest]

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

 

[Guest]

It's so easy when you know!

Thanks Biff - Fantastic!!!

 

[Biff]

You're welcome!

Biff

It's so easy when you know!

Thanks Biff - Fantastic!!!