Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
930
Conditional formatting based on whether cell is editable
posted

Hi

I'd like to conditionally format all the cells for which .CanEnterEditMode is False -- for example a grey background instead of white.

Was looking for an easy way to do this while keeping in mind that the program would set some cells read-only based on the input in other cells. So the appearance should change accordingly.

Thanks

Abhishek

 

Parents Reply Children
No Data