Conditional cell formatting

[Katarzyna]

Hi,

Is it possible to set conditional formatting for one cell, depending from another cell value? I mean something like this:

[A1>100][GREEN]#,##0;[A1<=-100][YELLOW]#,##0;[CYAN]#,##0

[serge]

did you added this feedback? I would like to vote for it?

[Veselin Tsvetanov]

Hi Katarzyna,

I am afraid, that the Spreadsheet widget does not offer support for custom formatting of a cell value, based on a value in another cell.

If you think, that the suggested would add considerable value to the widget functionality, I would suggest you to log it as a feature request in our Feedback portal. based on the support it receives from the community, we will decide on whether to proceed with its implementation or not.

Regards,
Veselin Tsvetanov
Progress Telerik

[serge]

is there a way to use a background instead of foreground? and another color, like hexa code?

[Veselin Tsvetanov]

The conditional formatting of a cell value does not allow styling (color) change that will be applied to the background instead of the foreground. I am afraid it would not accept a hexadecimal color code too.

As per the Feature request item, here is where you could cast your vote for the external value conditional formatting:

https://feedback.telerik.com/kendo-jquery-ui/1359682-spreadsheet-conditional-formatting-against-other-columns