Forum Discussion
EXCEL change cell fill color automatic
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)
Form Check box (in developer tab)
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.