Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|