formula that changes the color on another cell

[Guest]

I would like to set up a sheet where if I click on "yes or no" on a cell, it
will change the color on another cell. For example, when I click on a cell
if I obtain something, and mark the cell yes or no, it will change the task
name into different colors.

 

[Guest]

The best way to do this would be to use Conditional formatting.
Select the cell where you want the colour to change.
Select Format from the main menu, then Conditional Formatting.
Click the dropd-down box and select "Formula is"
As the criteria enter =A1="No"
Where A1 is the cell with the Yes/No,
The "No" representing the trigger value,
Then select the format you want if the cell has the trigger value.