Conditional formatting

W

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.
 
W

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
 
J

JE McGimpsey

One way:

Select A1 & B1. Choose Format/Conditional Formatting:

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