Forum Discussion
EXCEL change cell fill color automatic
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
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.
is there a way fro this to work for check boxes?
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)
