First, click on cell 1 or 2. Click Conditional Format under FORMAT on menu.
Choose "FORMULA IS" in combo window. Click in the next field, then type the
following.

For cell 1 or 2, type: =AND(cell-1="", cell-3<"")
Format accordingly.
Change cell reference to match your setup.

Les


"Willco3" wrote:

I have a workbook requiring data to be entered into 3 specific cells - how do
I turn a particular cell (say cell 1 and 2) a different color if a $amount is
entered into cell 3 but 1 & 2 have not been completed (if 1 & 2 have been
completed I dont want the color to change). Any help would be greatly
appreciated. Thanks.
--
DWillcox