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.