google-sheetsconditional-formatting

Conditional formatting comparing cell to cell values in a range


Pic with a table

Each column is a number of requests by month, so I would like to mark the values that 15% bigger, then in a previous month. (rows are "query name" and not important)

I made a custom formula: =C2>1,15*B2 for the range B2:T and some marks are confusing me. For example, why M2 cell is not marked its 26,5% bigger then L2. Also what's wrong with F2, its smaller then E2, why its marked? Is there some mistake with cell picked for comparison in custom formula?

GS link


Solution

  • Change the range setting to C2:T since your custom formula is =C2>1,15*B2