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!
Bookmarks