Excel Function Query

[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

 

[Nigel]

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