Conditional formatting

[Willco3]

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.

 

[WLMPilot]

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

 

[JE McGimpsey]

One way:

Select A1 & B1. Choose Format/Conditional Formatting:

CF1: Formula is =AND(C1<>"",COUNTA(A1:B1)<2)
Format1: <pattern>/<desired color>

 

[Willco3]

Thank you so much - you have saved me so much time - it worked.....