Hello,
is there a way to change cell color on certain cell selection without performing a macro?
For example, when I select any cell on column D, I need cell range A1:B3 to highlight in any color. Or to be distinguished in any other way. After I deselect column D, I need the highlight from range A1:B3 to disappear.
I know how to do that with macro, but that is not a very good solution, as it does not allow using UNDO function later. And as this macro run on Selection_change, I will never be able to use UNDO; even if I did not select column D. This make working with the file more complicated.
Is anyone aware of a walk around how to make certain cells to be highlighted without triggering a macro? Thank you in adcance!
is there a way to change cell color on certain cell selection without performing a macro?
For example, when I select any cell on column D, I need cell range A1:B3 to highlight in any color. Or to be distinguished in any other way. After I deselect column D, I need the highlight from range A1:B3 to disappear.
I know how to do that with macro, but that is not a very good solution, as it does not allow using UNDO function later. And as this macro run on Selection_change, I will never be able to use UNDO; even if I did not select column D. This make working with the file more complicated.
Is anyone aware of a walk around how to make certain cells to be highlighted without triggering a macro? Thank you in adcance!