Currently I have a custom formula in Google Spreadsheet as following:
=ArrayFormula(E1=MIN(if(ISERROR(FIND("NO",E$1)),E$2:E$100)))
Which highlights the cells with the minimum value in columns (without "NO"
as part of the column name, E$1
). And I would like to add another conditional formatting that highlights cells with values close to the column's minimum (say, given a range of [0, +0.1]
). How should I edit the existing formula?
For example, a column with values ["AVG1", 1.1, 2.3, 0.8, 0.85]
would have 0.8
highlighted, and I would like 0.85
also highlighted (since 0.85 - 0.8 < 0.1
).
p.s. a column with values ["NO_1", 1, 2, 3, 4]
would have nothing highlighted since "NO_1"
contains "NO"
as part of the column name.