Prev Previous Post   Next Post Next
  #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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 02:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"