Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 13
Post 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 367
Default 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


  #3   Report Post  
Junior Member
 
Posts: 13
Default

Thanks Carlo,

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

Thanks again,

Les

Quote:
Originally Posted by carlo View Post
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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
SUM if cell is Bold [email protected] Excel Discussion (Misc queries) 7 August 7th 06 02:46 PM
SUM if cell is Bold [email protected] Excel Worksheet Functions 7 August 7th 06 02:46 PM
Join bold and non-bold text in one cell bkincaid Excel Discussion (Misc queries) 3 March 21st 06 12:58 AM
How can i test a cell for bold style in a cell (Excel 2003)? Mike A. Excel Worksheet Functions 2 March 6th 06 07:23 PM
Checkbox formatting.. anyway to make the checks bold or standout m SSHO_99 Excel Worksheet Functions 0 March 16th 05 10:27 PM


All times are GMT +1. The time now is 06:00 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"