View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Daesthai Daesthai is offline
external usenet poster
 
Posts: 6
Default Format Control on large number of check boxes

When copying cells with functions, excel will automatically increment cell
IDs within the functions.

Is there a similar ability for checkboxes? I'm inserting a large number of
check boxes that affect conditional formatting. Is there a way to do this
without having to go into the Format Control for each individual checkbox to
set a cell link?

I'm working in Excel 2003, by the way.

Thanks for any help you can provide.