I would like to highlight a cell (C1) in yellow if the value in another cell (B1) is true.
I have tried typing in B1 or =B1 in the box in the screenshot below "Format cell values where this formula is true:" but C1 is always yellow.
Can someone point me in the right direction?
It seems that there is a bug in the formula rule evaluation and it is causing to behave erratically. I have logged the bug in our backlog on your behalf and I am hopeful that we'll be able to fix it soon. You can find the public item here: SpreadProcessing: Conditional formatting with formula rule is evaluated incorrectly and as always, you can subscribe to the item, in order to be notified when the bug is fixed.