Format the cell based on the value in the Source data
Abdul Rahman M
1
Reputation point
Hi Experts,
I want to identify the list of values containing 3 groups (each group saved in a different name in the Name Manager), in the
whole sheet with different colors for different groups. Which are randomly placed in the sheet with a double click of cells that
contains, one of the values in the group.
Each group should have a different color. Again with the same double click on any of the colored cells should back to their original format along with the group.
Constrains:
- With a double click, it should activate & Deactivate
2.Each group should have a different color
- All the values in the same group are colored by clicking any one of the values in a particular group and vise-versa
Thanks in advance.