Welcome Guest [Log In] [Register]
Welcome to the GRG Supercentenarian Forum. We hope you enjoy your visit.

You're currently viewing our forum as a guest. This means you are limited to certain areas of the board and you can only read the forum. If you want to ask a question, provide new information, or help other members, you can register as a Forum Member. The forum will ask you to validate your e-mail address. You will then be able to post in the "About Supercentenarians" category only. Registration is simple, fast, and completely free!

Join the GRG Supercentenarian Forum!

If you're already a Forum Member, you can log in below:

Username:   Password:
Add Reply
"Bold" for "World's Oldest Person"
Topic Started: 23 Mar 2012, 10:04 (384 Views)
Robert D. Young
Member Avatar
GRG Forum Co-Founder

Mark,

In the past, we used boldface for the World's Oldest Person titleholder. I'd like to go back to that format.

http://www.grg.org/Adams/B2.HTM

Sincerely,
Robert Young
Senior Consultant for Gerontology, Guinness World Records (from Nov 23 2005)
Senior Claims Researcher, Gerontology Research Group (from June 1999-2012, 2014).
Senior Database Administrator, Gerontology Research Group (from Dec 2012)
Director, GRG Supercentenarian Research and Database Division (from Feb 12 2015)
Founder, World's Oldest People Group (from June 2002)
Co-Founder, GRG Supercentenarian Forum (from 2011)
Bureaucrat, Gerontology Wiki (from Oct 2 2007)
Offline Profile Quote Post Goto Top
 
Mark E. Muir
Member Avatar
GRG Forum Co-Founder

Robert D. Young
23 Mar 2012, 10:04
Mark,

In the past, we used boldface for the World's Oldest Person titleholder. I'd like to go back to that format.

http://www.grg.org/Adams/B2.HTM

Sincerely,
Robert Young
Right, that should be easy to implement without doing it manually. In the Table B output file, I'd just have Excel look at the "Highest Rank" column for any instances of "1" and set conditional formatting to make the entire row in bold.

* MEM
Mark E. Muir
Gerontology Research Group (GRG) Correspondent, North America, (2011 - present) and Senior Administrator (2014 - present)
Co-Founder of GRG Supercentenarian Forum (12-Dec-2011 to present)
Offline Profile Quote Post Goto Top
 
Mark E. Muir
Member Avatar
GRG Forum Co-Founder

Mark E. Muir
23 Mar 2012, 10:08
Right, that should be easy to implement without doing it manually. In the Table B output file, I'd just have Excel look at the "Highest Rank" column for any instances of "1" and set conditional formatting to make the entire row in bold.

* MEM
Mark E. Muir
After a hiccup on my own part, I was able to implement the bold for World's Oldest Person titleholder (those with "Highest Rank" of 1) in the Table B output file.

The next Table B update (here in this SC Forum) will display this feature.

Cheers,

* MEM
Mark E. Muir
Gerontology Research Group (GRG) Correspondent, North America, (2011 - present) and Senior Administrator (2014 - present)
Co-Founder of GRG Supercentenarian Forum (12-Dec-2011 to present)
Offline Profile Quote Post Goto Top
 
Robert D. Young
Member Avatar
GRG Forum Co-Founder

I like the fact that you used conditional, rather than manual, formatting!
Senior Consultant for Gerontology, Guinness World Records (from Nov 23 2005)
Senior Claims Researcher, Gerontology Research Group (from June 1999-2012, 2014).
Senior Database Administrator, Gerontology Research Group (from Dec 2012)
Director, GRG Supercentenarian Research and Database Division (from Feb 12 2015)
Founder, World's Oldest People Group (from June 2002)
Co-Founder, GRG Supercentenarian Forum (from 2011)
Bureaucrat, Gerontology Wiki (from Oct 2 2007)
Offline Profile Quote Post Goto Top
 
1 user reading this topic (1 Guest and 0 Anonymous)
« Previous Topic · Feedback on GRG Tables · Next Topic »
Add Reply