Checkbox to Bold Adjacent Cell
 

I have 4 sets of 6 Checkboxes adjacent to text items across the page for a total of 24 items. When a box (A7) is checked I want the text (B7) to become BOLD.

I have the checkbox A7 linked to itself A7 and font and background the same color.

I assumed that I simply do conditional formating, but don't seem to be doing something right.

Thanks for any help,

Les

Checkbox to Bold Adjacent Cell
 

A7 is true or false i assume.

so select B7, goto conditional formatting.
choose formula is and enter
=A7
click on "format..." and select "bold" for the font.

that works fine for me.

hth

Carlo


On Dec 20, 9:37 am, Les Linton
wrote:
I have 4 sets of 6 Checkboxes adjacent to text items across the page for
a total of 24 items. When a box (A7) is checked I want the text (B7) to
become BOLD.

I have the checkbox A7 linked to itself A7 and font and background the
same color.

I assumed that I simply do conditional formating, but don't seem to be
doing something right.

Thanks for any help,

Les

--
Les Linton

Thanks Carlo,

Works fine, must have spent to much time looking at this yesterday.

Thanks again,

Les