How to alternate row colours based on text name
Requirement:
The user wants 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 wants to be able to uniquely or alternatively colour the rows based on the usernames.
Solution:
=MOD(INT(SUM(1/COUNTIF($A$2:$A2,$A$2:$A2))),2)=1
Obtained from the OzGrid Help Forum.
Solution provided by Rory.
See also: Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions and Index to new resources and reference sheets
See also:
| How to use a formula to return multiple matches in separate rows |
| How to print range excluding blank rows with formulas |
| How to combine rows with the same ID# but different columns |
| How to combine rows with the same ID# but different columns |
Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.
Gallery
