View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rodney Rodney is offline
external usenet poster
 
Posts: 29
Default Excel Function Query

Hi everyone,

Somehow i need a formula or something similar which will do the following.
Basically, i have a column (A) of cells with different dates in them (e.g.
11/10/07). I then have another column (B) with some blank cells and some
cells with numerical values in them. What i want to do is make only the blank
cells in column B turn blue if 60 days over the date in Column A passes. For
example, cell A1 contains the following date: 11/07/07 and Cell B1 is blank.
Therefore cell B1 should be blue because 60 days have passed since 11/07/07.

Hopefully someone can help, and that makes sense!

Thanks!
Rod