Hi
I have cells that I would like to highlight every time I click a cell.
I have managed to highlight the range of columns and cells when I click on a cell but the problem is I have different groups that would like to do that. What's happening is when I click on a cell it highlights the cells also on the other group.
A range would be columns and rows. Grouped in different areas of the same sheet and will have a gap in between.
I have attached the sample to give a clear idea. Conditional formatting is used.
Thank you very much.
Bookmarks