Conditional formatting not applied properly to sorted tables

[ethaniel]

Hello everyone!

Can you please help me with a problem with conditional formatting?

I made a simple income/expenses table, where the columns are:

1. Date
2. Details
3. Amount

The conditional formula is such that if the Details column matches the word “Income”, the whole row becomes accented.

However, some rows get accented properly, while others are chosen incorrectly.
Am i doing something wrong?

Attaching my spreadsheet in case someone wants to play with it.

03 - March 2024.ods (12.0 KB)

Thank you!

[ethaniel]

[ethaniel]

[JohnSUN]

Welcome!
Why $C3? Set it to $C1 - row of first cell in formatted rangt

[ethaniel]

My god! Thank you!!!