EXCEL change cell fill color automatic

[Burguel]

Hello, I want to change the look of one cell for example to the color red if it says 'no' and to green if it says 'yes' but this is not every single time, I want to automatize this, if I name the cell 'yes' it should turn green e.g. with 'red' to turn red, I mean the cell fill color with color here.

Greetings and thanks for help

[#2]

@Burguel 

Select the cells you want to color this way.

On the Home tab of the ribbon, select Conditional Formatting > New Rule...

Select 'format only cells that contain'.

Select 'Cell Value' from the first dropdown.

Select 'equal to' from the second dropdown.

Enter yes in the box next to it.

Click Format...

Activate the Fill tab.

Select green.

Click OK, then OK.

Repeat the above steps but with no and red.

[#3]

@Hans Vogelaar

is there a way fro this to work for check boxes?

[#4]

@squirt1302 

Which type of check box do you mean?

- Form check boxes (from the Developer tab)

- ActiveX check boxes (from the Developer tab)

- In-cell heck boxes (currently only available in beta to Microsoft 365 Insiders)

[#5]

@Hans Vogelaar 

Form Check box (in developer tab)

[#6]

@squirt1302 

Thanks. You can link such a check box to a cell. and then use Conditional Formatting on that cell.

Right-click the check box and select Format Control from the context menu:

The value of the linked cell will be TRUE/FALSE depending on whether the check box is ticked.

[#7]

ok. just out of curiosity, what's the process for activeX check box?

[#8]

@squirt1302 

They also have a linked cell.

To specify it, turn on Design Mode in the Controls group of the Developer tab of the ribbon.

Then right-click the check box and select Properties from the context menu.

Set the LinkedCell property: