Format the cell based on the value in the Source data

Abdul Rahman M 1 Reputation point
2021-11-10T13:26:58.163+00:00

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:

  1. With a double click, it should activate & Deactivate

2.Each group should have a different color

  1. 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.

0 comments No comments
{count} votes