Alternate row colours based on text name

• Hi hope someone can help.

I want to alternatively colour the rows of the sheet.

In column A is a list of user names (where the user name appears more than once) and I want to be able to uniquely or alternatively colour the rows based on the usernames.

Files

• Hello,

A tiny formula in Conditional Formatting ... :wink:

Hope this will help

Files

If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner

• Hello,

A tiny formula in Conditional Formatting ... :wink:

Hope this will help

Not quite. This is just alternate rows. As you will notice this is in user order. I want the rows for the first user to be one colour, then the next user to be another colour etc

• For alternating bands, you can use the following formula:

=MOD(INT(SUM(1/COUNTIF(\$A\$2:\$A2,\$A\$2:\$A2))),2)=1

Rory
Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why

• For alternating bands, you can use the following formula:

=MOD(INT(SUM(1/COUNTIF(\$A\$2:\$A2,\$A\$2:\$A2))),2)=1

That's the one.

Thank you very much