I want to apply a conditional format where the user can determine the colors to be used.
Thing is, the users all want to apply their own colors, and I don't want to create a dozen spreadsheets
So I was thinking about a simple grid where the users can enter the RGB values to "choose" the colors they want to use:
___R___G___B
1__255_0___0
2__0___255_0
3__0___0___255
4__120_120_120
These colors (in this case 1=red, 2=green, 3=blue and 4=gray) should then be applied to the actual cells that require the conditional formatting.
I would LOVE to create this without any VBA (so I can keep the spreadsheet "macro-free"), but if it's impossible without VBA a solution with VBA would be nice too.
Does anyone know if this has been "requested" before?
Thanks!
Thing is, the users all want to apply their own colors, and I don't want to create a dozen spreadsheets
So I was thinking about a simple grid where the users can enter the RGB values to "choose" the colors they want to use:
___R___G___B
1__255_0___0
2__0___255_0
3__0___0___255
4__120_120_120
These colors (in this case 1=red, 2=green, 3=blue and 4=gray) should then be applied to the actual cells that require the conditional formatting.
I would LOVE to create this without any VBA (so I can keep the spreadsheet "macro-free"), but if it's impossible without VBA a solution with VBA would be nice too.
Does anyone know if this has been "requested" before?
Thanks!