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 - 22 Nov 2007 14:57 GMT
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

Signature
Regards,
Nigel
nigelnospam@9sw.co.uk
> Hi everyone,
>
[quoted text clipped - 14 lines]
> Thanks!
> Rod