Hi experts,
I have a sheet with conditional formatting (color for a status value) for a specific row. Sometimes I set the values of a cell of this row manually. The condition is checked and the format is applied.
Sometimes I change the status value via vba but the format is NOT applied. Only when I enter the cell afterwards via double click and press enter the format will be applied.
How can I make excel check and apply the conditional format via vba? Is there any command?
Oh, I already tried such things like Range.Select, Range.Activate... but didn't work.
Thanks,
Sebastian
I have a sheet with conditional formatting (color for a status value) for a specific row. Sometimes I set the values of a cell of this row manually. The condition is checked and the format is applied.
Sometimes I change the status value via vba but the format is NOT applied. Only when I enter the cell afterwards via double click and press enter the format will be applied.
How can I make excel check and apply the conditional format via vba? Is there any command?
Oh, I already tried such things like Range.Select, Range.Activate... but didn't work.
Thanks,
Sebastian