Excel Function Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You can use conditional formatting.

Click on cell B1, choose Format from the menu and then choose Conditional
Formatting.

Set condition 1 (left hand drop down) to 'Formula Is' then in the empty box
to the right type in

=AND(A1>0,B1=0,NOW()-A1>60)

Set the Format to Patterns 'Blue' press OK

Copy this cell and 'Paste Special - Formats' to all relevant cells in column
B
 
Back
Top