bold font in accordance with active cell

Hi.
I need that when the cell is selected, if no bold font, then you will be in bold.

if the cell is selected, has a bold font, so will NOT be in bold.

Please Login or Register  to view this content.

Something like?

Please Login or Register  to view this content.

Hi.
Can I ask one more question?
how do I use this your code, so automatically?

Thank you!!!

You can place this code in a worksheet_change event if you want.

hi.

Yes!!

Thnks

Hi.
any tips on how to do this so automatically?

You can place this code in a worksheet_change event if you want.

YES!!
Thank you!

Hi.
this code does what I need it to do.

Please Login or Register  to view this content.

But I need only the interval that follows the code below
then the code should only go in column "A" to column "AD"

Please Login or Register  to view this content.

Your original solution does:
1. for each cursor movement on the worksheet
2. set the bold property to FALSE for ALL cells on the worksheet (irrespective of which cell is selected)
3. set the bold property to TRUE for the entire row of the selected cell

What I gave you was to switch the bold property ON when it was current OFF, and OFF when it was ON for a selected row. This is what you asked for in your first post.

If you want your original solution, but only want to apply the bold property from A to AD then use the following code:

Please Login or Register  to view this content.

Hi.
appeared the following error:

Run-time error '1004 ':
Method 'Range' of object '_Worsheet' failed

Change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Hi

soved by OllieB

thank you all!!

Originally Posted by thameem127

Try this

thaneem127, the request was to remove the bold property for all cells on the worksheet, and to subsequently apply the bold property again for columns A to AD of the currently selected row. How would your solution achieve this?