Forum Discussion
DevinDevin
Jun 26, 2023Copper Contributor
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....
NikolinoDE
Jun 26, 2023Platinum Contributor
In Excel for the web, conditional formatting formulas are limited to a subset of features and capabilities compared to the desktop version of Excel.
Unfortunately, the formula you provided, as far as I'm aware, isn't compatible with conditional formatting in Excel for the web.
But excel for web is always being equipped with new functions and possibilities, so it is always advisable to keep an eye on the innovations.
Here is a link that you will also find in this forum, where you can find out about all the updates that have been or will be added. Excel Blog