Hi,

I've looked through the conditional formatting section but can't find
anything.

Here is my problem...

A B C D E
1 DD SS WW 1
2 SS QQ EE 4

Now what I require is for section A1-D1 to highlight in red when A1=E1, so
for my example I would only expect to see one row highlighted because there
is only one match.

Your help again is much appreciated.

Regards,
James.