LinkBack URL
About LinkBacks
Mally 
There are table with "Group" column and I have all values sorted.
What formula should I use in conditional formatting to colorize whole row where similar Group values are identified?
GroupColor.png
There are table with "Group" column and I have all values sorted.
What formula should I use in conditional formatting to colorize whole row where similar Group values are identified?
GroupColor.png
Would you be able to add a helper column?
Please click the * icon below if I have helped.
By adding a helper column, would the attached work?
Actually, if you replace the formula in the conditional formatting to the following, a helper column is no longer necessary:
Formula:
=MOD(SUMPRODUCT(1/COUNTIF($C$3:$C3,$C$3:$C3)),2)=1
Melvinrobb,
Thanks for ideas!
1. Helper column is not possible as data is dynamic and I can't change table...
2. Something wrong with formula, in my document it doesn't work appropriate - sometimes it colorizes wrong rows in some reason
Take a look at the attached file and see if it works.
If it doesn't, please state what is not being applied appropriately, and what should be different.
Yep, but change B15 to "EE" and colorizing won't change...
Ok, I've used helper columnthanks you a lot, Melvinrobb!
My guess is that it is an array formula, and therefore not updating properly.
If you were able to create a helper column, the first solution should work perfectly. The formula I put in column B would automatically change with the data, and you could simply move the column off screen, or hide it.
Not sure of a solution otherwise.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks