Checkbox to Bold Adjacent Cell

L

Les Linton

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
 
C

carlo

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
 
L

Les Linton

Thanks Carlo,

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

Thanks again,

Les
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top