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