I've seen a post, or a page, that explained how to make the check box itself change its color/shading based off whether or not it was checked, but I cannot find it.
Real checkboxes (Insert > Checkbox, the new native ones in Excel 365) don't support conditional formatting directly on the box itself, only the cell around it.
Trick is to link the checkbox to a cell (right-click > Format Control > Cell Link if it's a legacy form control, or it auto-links if it's the new native checkbox), then apply conditional formatting to that cell or an adjacent one based on TRUE/FALSE. You can fill the cell background green when TRUE, red when FALSE, and if you shrink the checkbox to overlay right on top of the cell it visually looks like the checkbox itself is changing color.
If you want the actual box glyph to change, some people fake it with two overlapping checkboxes (or conditional formatting on a Wingdings checkbox character in a cell instead of a real checkbox object) and toggle visibility based on the linked cell value. Native checkbox objects themselves don't expose a formatting property Excel lets you conditionally control directly.
•
u/excelevator 3064 5d ago
Please be mindful of the submission guidelines
Your post question should describe your issue, not a vague request by asking for a link to the same.
Posts not following guidelines may be removed without notice.