• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Conditional format

cdi_747

New Member
Hello,

I have a list of people on my list. Each persons name appears multiple times, then the next persons name appears multiple times, then the next. I would like to know if there is a way to have 2 alternating colors for the names.

Ex.
John (all john rows one color)
John
John
John
John
John
Steve (all Steve rows another color)
Steve
Steve
Steve
Steve
Steve
Paul (all Paul rows alternate, but same color as John)
Paul
Paul
Paul
Paul
Paul
Raj (all Raj rows alternate, but same color as Steve)
Raj
Raj
Raj
Raj
Raj
Raj

Thank you!
 
Hi, cdi747!

Use the built-in search feature at top right and search for zebra stripes. There's an article about this.

And remember:
"How to get the Best Results at Chandoo.org
  • Quickly search the Web and Chandoo.org for help before posting. It is quite possible that your problem has been solved by someone else."
Should I tell you the source? :)

Regards!
 
Thank you. I had no idea about the phrase "zebra stripe". What do you mean by "Should I tell you the source?"
 
Thank you. I also love bullet number 7 "Please use language which conveys respect, appreciation and love".
I love this forum.

Also, what you are explaining to me about searching posts is contrary to what bullet number 9 suggests... "Start a new post every time you ask a question"...

I think you are correct is stating to look first though but this suggests otherwise, just fyi.
 

Attachments

Hi, cdi_747!

I'm not the author but I agree with most of them and try to almost always follow them (not always, I take certain poetic licenses from time to time), and 11th has priority before 7th, they should be in other order.

Check this link, it's from the website home page, not from these forums, so the 11th still valid, it's within Chandoo: :P
http://chandoo.org/wp/search/?q=zebra line

Regards!
 
Back
Top