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
|