Change Cell Appearance

[John]

I am using the spreadsheet to gather input from my users. We do the validation, however, to really make this program pop it would be great if there is a way to change the cell border color to a red boarder with a gradient starting from the cell boundary and moving inward so looking at the program it would be easy to find which values are out of range.  I have tried using the brush and gradient but I can only do it for the whole page.  I would settle for just changing the background of an out of range cell to red.  Are there any samples you can point me to?

Thanks, great control by the way.

John

[Nikolay Demirev]

Hello John,

If you are using data validation for validating the user input you could use Circle Invalid Data which is part of the Data Validation feature. Here you can read more about how to Circle Invalid Data.

If you want to set background on a cell you could set the Fill of this cell to red. Please note that if you set the fill of the cell this change will be included in your document on export. Here you can find how to set Fill to a cell.

If you do not want to use Circle Invalid Data and you do not want to change the document but simply show a colored rectangle behind the cell values, you could implement custom UI layer. This forum post shows how to implement a custom UI layer.

Regards,
Nikolay Demirev
Telerik

 

 

[John]

Thank you for the answers, I will read the posts.  I do not have the current version of Spreadsheet, so I am doing the validation with a work around I found on this sight, so these two posts should help.

THanks.