Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
|
|||
|
|||
Thanks Carlo,
Works fine, must have spent to much time looking at this yesterday. Thanks again, Les Quote:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUM if cell is Bold | Excel Discussion (Misc queries) | |||
SUM if cell is Bold | Excel Worksheet Functions | |||
Join bold and non-bold text in one cell | Excel Discussion (Misc queries) | |||
How can i test a cell for bold style in a cell (Excel 2003)? | Excel Worksheet Functions | |||
Checkbox formatting.. anyway to make the checks bold or standout m | Excel Worksheet Functions |