Conditional formatting
 

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

Conditional formatting
 

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

Conditional formatting
 

One way:

Select A1 & B1. Choose Format/Conditional Formatting:

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

In article ,
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.

Conditional formatting
 

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


"JE McGimpsey" wrote:

One way:

Select A1 & B1. Choose Format/Conditional Formatting:

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

In article ,
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.