Changing a cell colour when date in adjacent cell is >7days ago...?

[Spyke]

My last thread came back with no answers so i have made a few changes to my sheet hoping to make it possible.

How can i go about changing the colour of cell A1 when the date in B2 is more then 7 days old, then again to a new colour when it is 14days old. Im guessing it will be simply conditoonal formatting but cant quite get the formula right.

Or, if there is a way of doing this without using conditional formatting that would be better (because the date in B2 is only reading from another Tab, as conditional formatting wont read off another Tab, and i would rather not have to put in loads of new coloums to read the date from other tabs on my front sheet.).

If you didnt see my first thread and think you can help then please see it <<HERE>>

Thanks in advance!

[NBVC]

Select A1 and go to Format|Conditional Formatting

Choose, Formula Is and enter:

=AND($B2<>"",$B2<TODAY()-14)

Click Format and choose from Pattern tab

Click Ok

Click Add and repeat with formula:

=AND($B2<>"",$B2<TODAY()-7)