Hi,
I have a list of monthly returns (columns for Jan, Feb, Mar...) for a list of investments (in rows). I need to highlight instances where return values are identical for consecutive months (i.e. a single investment's returns are the same in Apr and May). I am having trouble figuring out how to do this separately for each investment.
In the attachment, D1 & E1 should be highlighted, D7-F7 should be highlighted, among others.
What is the formula for this?
Thank you,
Bookmarks