Thread: Why, please?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
an an is offline
external usenet poster
 
Posts: 37
Default 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