One of Excel's most underrated features for project ... Set the formatting style to a green background shade. Now, whenever you type Completed in any cell in column B within the range B2:B10 ...