Apply data validation to column

[Mischa Spelt]

Hi,

Is it possible to apply data validation to an entire column at once, using relative references?
E.g. I have a set of values in column B, and I would like to apply the condition "=B1 > 2.5" to B1, "=B2 > 2.5" to B2, etc.

When I add a new value somewhere in the column the formatting should also apply, so applying it cell-by-cell is not sufficient as the Rows property in XlsIO only loops through existing rows - it must be applied to the whole column.

Ideally, I would like to set
conditionalFormatting.FormulaR1C1 = "=RC > 2.5"
but unfortunately that property is read-only.

Thanks for your quick response!

[Mischa Spelt]

FYI, found some more evidence that this is a bug, so I created an issue in Direct-Trac.

[Sridhar]

Hi Mischa,

Thank you very much for the udpate.

Please follow up on the incident 84057 for further updates on this forum.

Please let us know if you require a ny further assitance on this.

Regards,
Sridhar.S