One way:
Set cell B1's background colour to green
Select cell B1 and conditional formatting
Change the setting to Formula is and paste this formula =ISBLANK($A$1)
Set the format to a background of red
Click Ok,Ok
Put this formula in Cell C1:
=IF(A1="","Not Complete","Complete")
Hope this helps.
Dom.