AbdulRahmanM-6963 avatar image
0 Votes"
AbdulRahmanM-6963 asked

Format the cell based on the value in the Source data

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.


  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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

0 Answers