How format a cell that changes to "Complete" or "Incomplete" [Closed]

Report
-
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