Forum Discussion
Office Scripts - How to use "RC" in a Script
Hello, I tried to use ROW(RC) in a conditionnal formula in an Office Script but the result is ROW('RC') and the formula doesn't work. If I use only ROW() my conditonnal formula doesn't work. Ho...
The formula property of a conditionlFormat object expects a formula in A1 mode, so:
Replace this:
const formula = '=EST.PAIR(LIGNE(LC))';with this:
const formula = '=EST.PAIR(LIGNE(' + range.getCell(0,0).getAddress() + '))';
thank you, it's better but I've to open the Conditionnal Panel and open the rule then click on [Apply] otherwise the Formula doesn't apply (but the formula is good !).