Conditional Formats Not Reading Cell Value

[Oscar Martin]

Hi,

My conditional format compares H4 to I4 (relative) and if they are not the same in value highlights the cells red. The formatting works for every cell except cell I4.

I can't work out why; any help would be much appreciated.

Thanx.

Oscar.

[ragulduy]

Hi, the value in I4 is:
1373.09388950276
and the value in H4 is:
1373.09
so they are not the same

I'd suggest either cleaning up the data so the values are the same or putting a round function into your conditional format rule. i.e.
=(round(H4,2)<>round(I4,2))