I am using excel 2003. I have set conditional formating to turn a cell green
when the cell value is the same as another cell value.

The source cell contains a formula that delivers a £value which I have set
to 2 decimal places.(£.pp) This is a financial value say £2.50 (£2.4990)

I then enter a financial value in the comparison cell as £2.50, which I want
it to identify as the same as the above value £2.50 (£2.4990)

It appears that the conditional formating is comparing the full numerical
value in both boxes, and therefore not detecting a "same as" condition.

I have verified this by removing the 2 decimal places formating and the cell
shows the full value, when I enter the same value the "same as" value
conditional format is triggered.

I could remove the 2 decimal places format permanently, which would resolve
the conditional format problem, however as this is a financial calculation I
would prefer to retain the 2 decimal places format.

Can anyone help in identifying a solution.

Many thanks
Andy