How format a cell that changes to "Complete" or "Incomplete"

Closed
Karl - Aug 21, 2017 at 11:18 PM
Hello,

How can I format a cell that changes to "Complete" or "Incomplete" when another cell linked to it has a specific text written on it i.e. Yes or No