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?
Regards
Anthony
Anna
Telerik team
commented on 02 Feb 2023, 03:05 PM
Hello Anthony,
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.
Hello Anthony,
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.
Regards,
Anna