Help - How to highlight incorrect value from 3 columns

[jonnyfox]

Hello,
New user, 1st post!
I have a Excel 2010 spreadsheet that contains 3 columns of (£) values. I am wanting to highlight a cell if one of these values do not match the other 2 columns. e.g below I would need the middle column to be highlighted as it does not match the other 2 cells.

25,449.47

25,451.65

25449.47

<tbody>
</tbody>

The thing to point out is that it can be any one of the cells that do not match, not necessarily the middle column and occasionally all cells will not match and all need to be highlighted.

I am sure I need to use the Conditional Formatting, but cannot figure the formula.

Any help would be great!

Thanks
- Jonny

 

[njimack]

Welcome to the board!

Assuming these cells are in A1:C1, try the below conditionall formatting on all 3 cells...
=COUNTIF($A1:$C1,A1)=1

 

[jonnyfox]

Neil - that works great! Now if I have rows and rows of these columns, how would I copy that formula down to through the next 250 rows? Remember I only need to match one row at a time.

 

[jonnyfox]

My columns are also in blocks of 3 but have many going across where I would like the formula copied. But as above I only need the formula to look at its specific row and column. Hope this makes sense.

 

[njimack]

Simply copying down will apply the formatting to each row. To apply to a wider range of columns, change the references from $A:$C so tgat they cover a wider range

 

[jonnyfox]

Hi Neil.

I copied the formula down by editing the Conditional Formatting rule and that worked fine. But when copying across that did not work. To get around this I created a new rule for every 3 columns. Is this the right way to do this?

I would like to insert an image to show you, but cannot figure how to do this....

Thanks

Jonny