Forum Discussion
Let(c, column(), c>2) doesn't work in conditional formatting.
I've recreated a simple example of the issue I am having. The column formula seems go break my conditional formatting, even though the same formula returns true when placed in a cell. https://1drv....
DevinDevin
Interesting. As for the wrapping it could be simplified a bit
=IF(1,LET(a, D8=COLUMN(D8), a) )Not sure why it doesn't work without that.
Main formula
=LET(
c, COLUMN(D8),
t, ROUND(OFFSET(D8, 0, -c + 2), 9),
j, INDIRECT(ADDRESS(5, IF(ISODD(c), c - 1, c))),
i, ROUND(IF(j < 0.08, j + 1, j), 9),
k, INDIRECT(ADDRESS(5, IF(ISODD(c), c, c + 1))),
o, ROUND(IF(k < 0.09, k + 1, k), 9),
AND(NOT(OR(j = "", k = "")), t >= i, t < o)
)used in cells always return FALSE. Could you provide sample data where it returns TRUE as well to play with it?