Hi,
I have 2 questions:

1. I have 2 columns "Order Date" and "Received Date" in my spreadsheet that
tracks the delivery date of my order. I want the cell in Order Date to turn
Red when the Order Date exceeds 14 days and the cell in Received Date is
still not entered. How do I put the formula to allow for this?

2. I created a formula which references a cell in another spreadsheet. How
do I drag the formula from one cell to another, with the formula
automatically updating the cell address? What happened was, eg. Cell B1 has a
CF that references to Cell A1. When I drag the cell B1 to cell B2, the B2
cell still references the cell A1 instead of A2.

Pls help! Thanks a lot!