Help : Conditional Formatting

Hi Guys,

I'm hoping to reach out and get a bit of help with conditional formatting.

I have thee columns all in a little row - if the three don't match - then I need to highlight them red. The contents is alpha numeric and I need all three columns to highlights.

So if A does not equal B AND not equal C the rows the cells in A, B and C need to highlight (this needs to include if there is a blank in there as well). I need to apply this from row 2 through to row 2848.

I've tried ands, ifs, ors, <> and =... I've $ and no $... and I'm just having no luck.

Any help would be most appreciated.

Thanks,

The N00b