When a cell is highlighted, then ...

I work for a printing company and I receive spreadsheets with new jobs that are posted daily. Each row includes a job number, description and the total quantity of pieces that need to be printed. What a job is completed, the production team highlights the row with a specific color. Is there a way to use the highlighted color in a formula, such as "if a cell is a certain color, then place the word "complete" in a specific cell"? I tried just to get the production team to select the word "complete" from a drop down list, but old habits die hard and they can't get away from just highlighting the row. Is this possible? Thanks!

You cannot use formulas to query the internal colour of a cell, but you can use VBA to do so or, as you use 2010, you can sort on cell colours: Data -> Sort -> Sort On "Cell Colour".