ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   format control on large number of checkboxes (https://www.excelbanter.com/excel-worksheet-functions/145356-format-control-large-number-checkboxes.html)

Daesthai

format control on large number of checkboxes
 
When copying cells with formulae, excel auto-increments cell ID numbers.

Is there a similar setup/tool available for copying check boxes? I'm
creating a large number of checkboxes that affect conditional formatting in a
bunch of cells. Is there a way to do this without having to go into the
Format Control for each individual box to set a cell link?


All times are GMT +1. The time now is 08:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com