Conditional formatting

[VegasNath]

I am trying to highlight differences between 2 ranges of data (ignoring rounding errors), using CF, but I am not getting the expected results.

Any idea where I am going wrong?

CF.GIF

[HansV]

You provide far too little information, but my guess is that you'd need to round the cell value too. Let's say that the active cell is C4.
- Select "Formula Is" from the first dropdown.
- Change the formula to =ROUND(C4,2)=ROUND(F4,2)
- Similar for Condition 2, but with =ROUND(C4,2)<>ROUND(F4,2)

[StuartR]

You don't really need to use TWO conditions for this. Simply colour the cell to match one of the two conditions, and the other condition will override the defaults. Note, this only works because the two conditions are exact opposites of each other, so that when one is true the other is false.

[VegasNath]

Thankyou both.