I have an Excel sheet as a database, where each row has a category, and are always sorted by category.
Category Item 1 AAA jjj 2 AAA kkk 3 AAA lll 4 BBB mmm 5 BBB nnn 6 CCC ooo 7 CCC ppp 8 CCC qqq 9 DDD rrr
I use conditional formatting to visually group the categories: e.g. the first row for a new category should have a border above it, and the category value should be bold. I do this via a formula applied to the row like
= $A2<>$A1 and it works perfectly...until I use filtering to hide rows.
For example, if filtering hides row
6/CCC/ooo then rows 7 and 8 appear to be part of the BBB category.
Is there any way to create a conditional formatting formula that says "if the value in this cell is different from the value in the first VISIBLE row above me"?