I have a cell with the following conditions to compare its value against the cell in the previous row.
Cell Value <> =OFFSET(INDIRECT(ADDRESS(ROW(), COLUMN())),-1,0)
Cell Value = =OFFSET(INDIRECT(ADDRESS(ROW(), COLUMN())),-1,0)
This works well, except for if I use a formula in the cell. When I do, the first highlight (red) is always chosen. I'm guessing because the "value" of the cell is the formula, and not the result of the formula.
Example: A1 := =24 A2 := =DEC2HEX(36)
A2 would be formatted "red", despite both cells displaying the text "24".
Is it possible for conditional formatting to compare based on the displayed text in the cell, and not the underlying formulas?