Answer for Q1)
Assuming your Order dates are in column B, and received dates are in column
C, then,
select cells B2 until the last cell in column B, and go to Format
Conditional Formatting.

Under condition 1, change "Cell Value Is" to "Formula Is" in the dropdown.
In the text box next to it, paste the following formula:
=AND($B2+14<TODAY(),ISBLANK($C2))

Click the "Format..." button and change the cell formatting to red, and
click OK twice to dismiss the Format Cells and Conditional Formatting dialog
boxes.

Explanation
===========
Although you have selected several cells in column B, you've probably
started with B2 and ended some other row in column B. As a result, the
conditional formatting is defined with respect to B2, and the same rules
apply similarly to cells below B2.
$B2 + 14 < TODAY() checks if the order date is more than 2 weeks before
today. ISBLANK($C2) checks if the received date column for the particular
row (here row 2) is empty. If both these conditions are satisfied, the
formatting specified is applied.

If you select row B23, the formula will appear as:
=AND($B23+14<TODAY(),ISBLANK($C23))
in the Conditional Formatting box.

Hope this helps.

"spacerocket" wrote:

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!