This is a migrated thread and some comments may be shown as answers.

Conditional cell formatting

1 Answer 33 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Katarzyna
Top achievements
Rank 1
Katarzyna asked on 11 Aug 2017, 11:29 AM

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
Top achievements
Rank 2
Bronze
Iron
Iron
commented on 04 May 2021, 10:06 AM

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

1 Answer, 1 is accepted

Sort by
0
Veselin Tsvetanov
Telerik team
answered on 15 Aug 2017, 08:38 AM
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
Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
serge
Top achievements
Rank 2
Bronze
Iron
Iron
commented on 04 May 2021, 10:07 AM

is there a way to use a background instead of foreground? and another color, like hexa code?
Veselin Tsvetanov
Telerik team
commented on 05 May 2021, 01:04 PM

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

Tags
Spreadsheet
Asked by
Katarzyna
Top achievements
Rank 1
Answers by
Veselin Tsvetanov
Telerik team
Share this question
or