reference cell, relative to filtered data

Question

Hi, I have an odd situation:

I am trying to create a conditional formula that compares a cell to the cell below it.  If the two cells are not the same (text, not numbers), it underlines the entire row.

I have created this in conditional formulas, and it works like a charm.  The problem is when I filter the data in my sheet.  The rule still compares each row to the row below it.  I need it to compare each visible row to the visible row below.

I understand absolute cell references vs relative cell references.  How do I create a reference relative to filtered cells?  I can't figure out how to use ofset or index to do this, as the distance to the next visible row could change from one row to the next.

Thanks

Answer 1

AFAIK this is how it works and there is no workaround..... Even tried using the index and offset functions as you have mentioned not able to produce the results....

Answer 2

Hi,

You may refer to my solution at the following link on my website - http://www.ashishmathur.com/compare-value-of-one-cell-with-value-of-next-visible-cell-of-a-filtered-range/

For follow up question/comments, please post in the Comments section of the link above.

Hope this helps.

Answer 3

Did anyone find an answer to this?  Some kind of VBA coding??