Fill colour adjacent cell based on value first cell
From AA Arens@21:1/5 to All on Fri Jun 18 01:30:25 2021
I use Data Validation--> List. With conditional formatting fill colour is assigned when choosing a certain value from the list.
How to get adjacent cells to be coloured as well when a particular value is choosen for the first mentioned cell?