So not sure if this is even a valid function. So in my workbook for example on sheet 1 i have a list of colors: red, blue, green, etc. On that page i have it selected as a "range" have the name defined and so on so that on the sheet where needed i can access the drop down, and i have simple conditional formatting rules to color the cell "blue" when it sees that blue was selected. But i have these same colors and lists needed across 3 separate sheets. So traditionally i would just created rules on each sheet "see blue, turn blue". But is there a to create this list only on sheet 1 with the correct colors associated to it, but it also carry the conditional rules across multiple sheets when i use the list? So if sheet 1 has the full list of color named and correctly colored, and i am on sheet 5 and select red from the drop down, is there a way to have it also show up red.
I think i can do it with Kutools? But using that isn't a valid option. So just reaching out for help, thanks
I think i can do it with Kutools? But using that isn't a valid option. So just reaching out for help, thanks