Hi folks
I would like to conditionally format alternate rows every time the unique label changes
In column B
I can get part way there using this formula in column d
=MOD(SUMPRODUCT(--(C2:C100=C3:C101)),2)
Which correctly selects the changed rows however I would like the complete row formatted and I would like if possible the alternate rows also formatted
I have attached an example
Column a and b is what I would like to end up with.
Green:
Applies to for both green and yellow: =$A$2:$D$70
Please Login or Register to view this content.
Last edited by protonLeah; 06-14-2016 at 06:06 PM.
Ben Van Johnson
Hi Ben , thanks
are you suggesting I need two conditional formatting formula's ?
if so I have tried that and cant get it to work
You need a formula for each color (you already had one for yellow) unless you want to start with the entire range as one color, say, green, and only apply the yellow conditional format.
Last edited by protonLeah; 06-14-2016 at 11:14 PM.
Thanks Ben
looked at it again today with a clear head, all makes sense now ta.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks