Conditional Formatting formula - if cell is bold Excel 2010

[falcios]

Is there a formula to highlight the entire data range row if one of the cells is in bold?

Thanks in advance.

 

[PaddyD]

you should be able to adapt the technique described here:

https://www.mrexcel.com/forum/excel-questions/20611-info-only-get-cell-arguments.html

using tyupe_num 20 to feed a conditional format. Post back if you can't get it sorted.

 

[dUBBINS]

I do not believe it could be possible to detect BOLD with a formula. Because it is font formatting. I don't think ASCII is used to create bold characters and I am not sure what else would come close to detecting it. You could write a macro that detects BOLD print and highlights the row. I would recommend that it be a button you press on your spreadsheet, but you could make it automatic. The latter can slow down your spreadsheet greatly, but not knowing your spreadsheet, maybe it wouldn't be an issue.

 

[dUBBINS]

you should be able to adapt the technique described here:

https://www.mrexcel.com/forum/excel-questions/20611-info-only-get-cell-arguments.html

using tyupe_num 20 to feed a conditional format. Post back if you can't get it sorted.

I stand corrected, nice tip, PaddyD. I am going to peruse this now.

 

[shg]

I would use VBA before using Excel4 macros. Both require that you save the workbook as a macro-enabled file, but VBA is more familiar and supportable.

 

[PaddyD]

"I would use <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-top-style: initial; border-right-style: initial; border-bottom-style: dotted; border-left-style: initial; border-top-color: initial; border-right-color: initial; border-bottom-color: rgb(0, 0, 0); border-left-color: initial; border-image: initial; cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym> before using Excel4 macros"

I wholeheartedly agree