Why, please?
 

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

Why, please?
 

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


"an" wrote:

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

Why, please?
 

Thanks for reply.

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

"Gary''s Student" wrote:

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


"an" wrote:

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

Why, please?
 

Ok, GS.

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

Thank you very much for your help.
an


"Gary''s Student" wrote:

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


"an" wrote:

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