Forum Discussion
Any Help? Change the color of a named cell range to match the color of a cell on another page.
Any help on this matter would be greatly appreciated.
I am trying to change the color of a named cell range to match the color of a cell on another page. In the provided example, the named cell range on the SpaVillas_Cantor sheet is the address, ex. 4901 Cinzia is called _4901_Cinzia.
Ultimately I would like to enter a value in the "Y" column (Ex. NBP) and have it change the color of that cell to the appropriate color, and then change the named cell reference on the other page to match that color. _4901_Cinzia. on the SpaVillas_Cantor sheet to green.
Maybe you can try using a a conditional formatting rule based on a vlookup? See below screenshot and example file for reference on how to accomplish the task:
Thank you so much for your help. I think this will work just have to fool around with it a little bit. Thanks again.
