Why, please?

[an]

Hi!

Excel 2007.

In Conditional Formating I have a formulae =$U3<MONTH(TODAY())*$H3.
I apply this formulae to =$U119<MONTH(TODAY())*$H119.

Work fine except on the Col 'U' there are 6 unduly collored cells.
If I add 0,0000000000001 to each cell, those cells change to not collered.

This is a bug, please?
Thanks in advance.
an

 

[Gary''s Student]

It's probably simple round-off error. Use the ROUND() function to force a
precise result.

 

[an]

Thanks for reply.

Who I use Round() with =SUM(I91:T91) in cell with Conditional Formatting,
please?
an

 

[an]

Ok, GS.

Work fine with =ROUND(SUM(xx;xx);06)

Thank you very much for your help.
an