Forum Discussion
Kevin L. Lovell, PGA
Jul 05, 2018Copper Contributor
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 ...
Matt Mickle
Jul 06, 2018Bronze Contributor
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:
Kevin L. Lovell, PGA
Jul 10, 2018Copper Contributor
Thank you so much for your help. I think this will work just have to fool around with it a little bit. Thanks again.