Spreadsheet Conditional Formatting Using A Formula

0 Answers 51 Views
Spreadsheet
Anthony
Top achievements
Rank 1
Veteran
Anthony asked on 01 Feb 2023, 04:54 AM

Hi,

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.

Regards,

Anna

No answers yet. Maybe you can help?

Tags
Spreadsheet
Asked by
Anthony
Top achievements
Rank 1
Veteran
Share this question
or