Checkbox to Bold Adjacent Cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Les Linton - 20 Dec 2007 00:37 GMT

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

Signature

Les Linton

Reply to this Message

carlo - 20 Dec 2007 02:18 GMT

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

> 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
[quoted text clipped - 12 lines]
> --
> Les Linton

Reply to this Message

Les Linton - 20 Dec 2007 13:39 GMT

Thanks Carlo,

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

Thanks again,

Les

carlo;601996 Wrote:

> A7 is true or false i assume.
>
[quoted text clipped - 31 lines]
> > --
> > Les Linton-

Signature

Les Linton

Reply to this Message