ExcelBanter - Automatic Bolding and Background Coloring

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Automatic Bolding and Background Coloring (https://www.excelbanter.com/excel-programming/303701-re-automatic-bolding-background-coloring.html)

Automatic Bolding and Background Coloring

Hi
see my response in worksheet.functions

--
Regards
Frank Kabel
Frankfurt, Germany

OriginalStealth wrote:
ID TITLE TitleID

66749 Devil's Advocate 323484
66750 Warner Cable 3 301350
66750 Warner Cable 3 301350
66750 Warner Cable 3 301350
66750 Warner Cable 3 301350
66795 Paycheck 322940

1. How can I double-click on the ID and have the whole
line bold and the row changes to yellow.

2. When I click an ID that has duplicates beneath it, the
first line bolds and all of them turn yellow.

Thanks in advance
OS

Automatic Bolding and Background Coloring

Frank Kabel in Germany, you're a godsend !

Thank you so much.

hglamy

"Frank Kabel" schrieb im Newsbeitrag
...
Hi
see my response in worksheet.functions

--
Regards
Frank Kabel
Frankfurt, Germany

OriginalStealth wrote:
ID TITLE TitleID

66749 Devil's Advocate 323484
66750 Warner Cable 3 301350
66750 Warner Cable 3 301350
66750 Warner Cable 3 301350
66750 Warner Cable 3 301350
66795 Paycheck 322940

1. How can I double-click on the ID and have the whole
line bold and the row changes to yellow.

2. When I click an ID that has duplicates beneath it, the
first line bolds and all of them turn yellow.

Thanks in advance
OS