Alternate row colours based on text name

  • 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

  • Glad to help. :)

    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

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!