Checkbox selected make adjoining cells bold.

[jbstephenson]

I am relatively new to creating spreadsheets and using macros. I have a workbook with several sheets with varing number of checkboxes on each sheet. The checkboxes are linked to adjoining hidden cells. c-b, l-k, and u-t. What I would like to do if possible, is have is when a checkbox is selected the adjoing text will turn bold, and when checkbox either cleared, or check removed text returns to normal. The sheets will be printed and the data entered into another program. Ex: when c7 checked the adjoining cells d:7 -h:7 will turn bold. Checkboxes in column c relate to columns d:h, clolumn l = m:q and u = v:z. Which would make it easier to read when printed. On some sheets there may be only a few checked and this would make it easier to locate the data. The whole sheet needs to be printed as additional changes may be added later, but will be marked by pen. The clear button will remove all checkboxes from entire workbook and clear text fields, exhibitor name and number. Could possible use the clear button to change text back after printed, or create a print button that will print that individual sheet and change text back to normal on that sheet only. I have attached a copy of the workbook, all the tabs are not finished as will update as I get each sheet to work properly.
Thanks for any help in advance.

[modytrane]

see attached book.
column V is set up.
Use conditional formatting.
You can check the conditional formatting for cells in column V and copy it to other columns.
modytrane

[jbstephenson]

That will work, but is there an easier way to setup the conditional formatting, without having to do each column seperately. I tried selecting the adjoing columns and doing the format, The last column would be bold and the only thing that would change is the first one, next to checkbox.

[modytrane]

You can assign conditional formatting to one cell.
Make sure the conditional formatting formula is =T7, without the $ signs.
In other word, make sure it's not =$T$7.
Then you can copy that cell, selct all other cells and use Paste Special, select "Format" to assign that conditional format to all other cells.
modytrane