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 cel...
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.
- ok. just out of curiosity, what's the process for activeX check box?